Forum Discussion
Help changing cell fill if a cell is populated.
Hi all, I'm currently writing a new schedule for our planned maintenance. I need to be able to change cell fill for the next four cells to green, once a cell has the value Y in it. For exampl...
But you mentioned A1:A4 earlier. That is, values in the same column. Now you show F8:I8 being on the same row.
Change the rule to =$F8="y" and it shall work.
It does! See picture below (on a Mac, but it's similar on the PC)
I need F8-I8 to turn green if F8 is Y, is that the correct Conditional Formatting Rule? Apologies, I'm not the best at Excel!
