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.
|