|
|
|
|
#1
09-23-2018, 05:24 PM
|
|||
|
|||
How about this? Notice on a holiday and/or on a weekend, you need to transfer the values from the day before in order to fulfill the desired conditional format for the next trading day. The font and fill are both grey.
You posted this thread in Excel Programming, but I don't see any reason why you need any VBA as you can achieve this thru CF. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 looking to change cell color by typing number into the cell
|
ibs | Word Tables | 1 | 11-22-2016 06:31 PM |
|
Entering a number in a cell causes it to fill with the color of a nearby cell
|
Bill Martz | Excel | 1 | 04-23-2015 07:57 PM |
|
Cell Background Color: Base it on Content of Cell?
|
tatihulot | Excel | 4 | 08-14-2013 03:24 PM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
| How can I make a cell color RED under the Today's date cell? | Learner7 | Excel | 2 | 07-08-2010 12:52 AM |
Windows Vista 
Office 2007
Hybrid Mode