Hi,



I have numbers in column "C" which either starts with first 2 letters as "35" or "45". I would like to highlight the numbers which starts with "45" as first two characters using conditional formatting. How can I do that? Please support.

Select col C
use =LEFT($C1,2)="45" as CF and format as required



Happy New Year

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post