Forum Discussion
Problem with conditional formatting?
Does anyone know if I can change the colour of box A24 if box M24 says yes?
Hi Haytham
Thanks for your reply but the only cell that changed colour was M24 but I wanted A24 to change as well. do you know how to make it work?
thanks again
Hi Stephen,
You have to select the cell A24 before you apply the rule.
Please note that the rule will be applied to the selected cell or range of cells.
I guess you have selected the cell M24 before you applied the rule!
