Change a cell color in Excel once it is activated

Titotolo 2 Posts Friday November 17, 2017Registration date November 28, 2017 Last seen - Nov 28, 2017 at 07:50 PM - Latest reply: ac3mark 8371 Posts Monday June 3, 2013Registration dateModeratorStatus December 15, 2017 Last seen
- Nov 29, 2017 at 04:27 PM
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


See more 

1 reply

Reply to this topic
ac3mark 8371 Posts Monday June 3, 2013Registration dateModeratorStatus December 15, 2017 Last seen - Nov 29, 2017 at 04:27 PM
0
Helpful
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....
http://ccm.net/forum/affich-1013945-use-conditional-formatting-to-highlighting-cells-based-on-name

Have fun!
Respond to ac3mark