Change a cell color in Excel once it is activated

Closed
Titotolo Posts 2 Registration date Friday November 17, 2017 Status Member Last seen November 28, 2017 - Updated on Nov 29, 2017 at 01:11 AM
 Blocked Profile - 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


1 reply

Blocked Profile
Nov 29, 2017 at 04:27 PM
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!
0