Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formating: ifs and highlighting rows
my spreadsheet documents error incidents, with each row showing the date the
incident was discovered (column A) and the date it was resolved (column I). it also calculates networkdays (column J) -- unless column I=0 -- and references an array of holiday dates on another sheet. i would like to create a conditional format that will identify rows with an incident, but no resolution date, then highlight the row and possibly even show "unresolved" in column J cell of that row. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlighting an entire row using conditional formating | Excel Discussion (Misc queries) | |||
Conditional formating - Highlighting items in a separate column | Excel Discussion (Misc queries) | |||
Help using Conditional Formating of Entire Rows | Excel Worksheet Functions | |||
conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) | |||
HELP ME PLEASE!! CONDITIONAL FORMATING HIGHLIGHTING CELLS. | Excel Discussion (Misc queries) |