Change a cell color in Excel once it is activated
Closed
Titotolo
Posts
1
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
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
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
Related:
- Change a cell color in Excel once it is activated
- Notepad++ change background color - Guide
- How to change date format in excel - Guide
- How to change author in excel - Guide
- Number to words in excel - Guide
- Gif in excel - Guide
1 response
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!
=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!