|
|
|
|
#1
09-24-2018, 11:28 PM
|
|||
|
|||
Quote:
Activate a cell in column B with prices, and select from Menu Home>Conditional Formatting>Manage Rules. 5 rules (a rule for every color) are defined there. When you want to apply conditional formatting to columns C and D too, you need additional 2 calculated columns with previous workday values for those columns, and additional 5 conditional formatting rules for every of those columns. 
|
|
|
|
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 8 
Office 2016
Hybrid Mode