| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting for "overdue" status
Hi, a conditional formatting question. I've got a task list. Two
columns are relevant. Column A - "Due Date" Column B - "Complete?" Column A is in date format, Column B just has an "x" in it if the task is complete. What I want is for the date in Column A to show up in red type if the "Due Date" is "greater than" today's date, and at the same time there's no "x" in the corresponding entry in Column B. Is this doable? I see how to do basic conditional formatting, but I don't see how to tie in values from different columns/cells. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
| conditional formatting "if part of cell contents contains string" | Excel Worksheet Functions | |||
| Conditional Formatting Bottom 10 with "ties" | Excel Discussion (Misc queries) | |||
| =IF((TODAY()-B8)30, "Overdue", "Current"), | Excel Discussion (Misc queries) | |||
| Conditional Formatting-can a "then" be placed with the "if". | Excel Worksheet Functions | |||
Threaded Mode
