![]() |
#6
|
|||
|
|||
![]()
Just to show what I am trying to do here, I have added a screen grab (I hope). When D32 is empty (it's the figures column, as B32/C32 are joined), I would like the text in A32 (Filter) to become grey (ghost text). If figures are then added back into D32, the text in A32 returns to black. Hope that makes sense.
![]() |
Tags |
conditional formatting, drop down menu, if formatting |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formatting unprotected cell in protected w/s makes the cell locked? | tango356 | Excel | 2 | 01-23-2017 02:13 PM |
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting | hanvyj | Excel Programming | 0 | 08-28-2015 01:15 AM |
![]() |
Saywarder | Excel | 1 | 04-20-2015 11:29 AM |
Conditional Cell Formatting: Alternating Cell Checks | corbott | Excel | 4 | 12-16-2014 01:51 PM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |