| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Does a highlight row comand exist for Excel conditional formulas?
I am trying to write a conditional formula and if a certain condition is met,
the entire row will be highlighted. Essentially, I am searching through a suspense database and if a task is overdue I would like the conditional formula to highlight the row. Here is what I am trying to do... =IF(AND(B5<=TODAY(),I5<"Closed"),highlightrowcolo r=yellow,"") Obviously the "highlightrowcolor" is not a command but if someone knows what would work I would appreciate it tremendously if you could share that information. Thanks in advance, Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highlight cells equals sum, not count | Excel Discussion (Misc queries) | |||
| How can I highlight every other group of data? | Excel Discussion (Misc queries) | |||
| Highlight row given certain conditions | Excel Worksheet Functions | |||
| How do I highlight all lookup formulas in a worksheet in one shot. | Excel Discussion (Misc queries) | |||
| Highlight Data | Excel Discussion (Misc queries) | |||
Threaded Mode
