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

Hello

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

Thanks

Ray

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.

Thanks Excel Fox

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

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