Forum Discussion
Solved
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.
Select A1:A4. Create a Conditional Format with the following formula:
=A$1="y"
This only seems to fill the cells which actually have the Y in. I require it to fill all four cells as long as A1 has is populated with Y.
