Quote:
Originally Posted by COgreywolf
What I don't get is the mechanics of how the cells in A5:A16 get the appropriate colors assigned.
|
Search for Conditional Formatting in help!
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.