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 example: Y is entered into A1, so I need A1, A2, A3 and A4 to turn green.
Thank you in advance for your help.
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.
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!
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!
