Change a cell color in Excel once it is activated

Closed
Report
Posts
2
Registration date
Friday November 17, 2017
Status
Member
Last seen
November 28, 2017
-
 Blocked Profile -
Hello,
I have a little program in a Book with two sheets one called DATA and another called FORM, in this sheet I have placed the formula =DATA!$A$8, in the same cell A8 in the DATA sheet Whatevere I write it will be placed in the formula in the FORM sheet, what I want also is to change the color of the cells which are used once the formula is activated (it might be more than one cell if the text passes more than one cell), I wonder if this can be done I have tried without luck, can someone help me???
Thanks


1 reply


It is conditional formatting. Select the cells you wish to apply the formating to, and build a formula that says:
=IF($A$8<>"")
and set a true to blue color. Now, when a cell is not blank it will turn blue.

I hope this helps. Check this out for an example....
https://ccm.net/forum/affich-1013945-use-conditional-formatting-to-highlighting-cells-based-on-name

Have fun!