| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting with formula (multiple criteria)
I have dates in one column to show the due date of an action item. In the
"status" column to the right, I have whether or not that action item is "closed", "open", or "in progress." I would like to conditionally format the column with dates with red font if the date is in the past and the status is not "closed." Can anyone help me with the formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting - multiple criteria | Excel Worksheet Functions | |||
| Conditional Formatting with multiple criteria | Excel Discussion (Misc queries) | |||
| conditional formatting, multiple criteria | Excel Worksheet Functions | |||
| conditional formatting, multiple criteria | Excel Discussion (Misc queries) | |||
| Multiple Criteria for Conditional Formatting | Excel Worksheet Functions | |||
Threaded Mode
