Hello
How do I make the rows (AAAAA to Invoice Number) turn Green when the Invoice Number starts with 301
Thanks
Ray
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.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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)
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks