Color A Row Of Cells Using Conditional Format Based On A Value In Cell

[raybugge]

Hello

How do I make the rows (AAAAA to Invoice Number) turn Green when the Invoice Number starts with 301

Thanks

Ray

[Excel Fox]

Select entire area starting from D5 cell to R10 and in the conditional format, go to the formula section and use =LEFT($R5,3)="301", and select the formatting you want and click OK.

[raybugge]

Thanks Excel Fox

[raybugge]

If i want to make it turn green only if the numbers are between 30100000 and 30199999 what formula would i use please
Cheers
Ray

[Excel Fox]

Change the formula to =AND($R5>=30100000,$R5<30200000)