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
Related:
- Change a cell color in Excel once it is activated
- Notepad++ change background color - Guide
- How to change author in excel - Guide
- How to change date format in excel - Guide
- Change computer name cmd - Guide
- Number to words 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!
