Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a spreadsheet that basically holds date values in one column going down. Basically what i want to do is say "If the date in a cell is 1 day away then turn the cell fill color red, if it's 2-3 days away turn it yellow" Is there a one liner that can be used as a global statement within the sheet to evaluate all cells on the sheet and change color for those that satisfy the condition or must this be done cell by cell? Please help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic Conditional Formatting | Excel Discussion (Misc queries) | |||
automatic formatting | Excel Discussion (Misc queries) | |||
automatic formatting | Excel Worksheet Functions | |||
Automatic formatting help? | Excel Discussion (Misc queries) | |||
Automatic Row Formatting | Excel Discussion (Misc queries) |