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.
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.
Apologies mate, it's been a long day, all sorted now, thank you for your help!