Home |
Search |
Today's Posts |
#1
|
|||
|
|||
more than 3 conditional formats
I'm trying to produce a spreadsheet whereby a date is entered when an
activity should be completed by. I want it to produce the following outcomes: 1) when activity is selected and cell is orange and shows date to be completed by 2) when completed before due date, date is entered and cell turns green 3) when due date has passed cell turns red I can't seem to fit all this into conditional formatting and don't know how to carry all this out using IF. Help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two Conditional Formats | Excel Discussion (Misc queries) | |||
Number of Conditional Formats | Excel Worksheet Functions | |||
how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
how do i get more than three conditional formats in excel | Excel Worksheet Functions | |||
Conditional Formats in Excel | Excel Worksheet Functions |