Thread
:
conditional formating: ifs and highlighting rows
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
conditional formating: ifs and highlighting rows
Well, you have to decide which way you want to go with this.
If you leave column J blank then you can base the CF on column J being
blank.
If you want column J to return "unresolved" then you can base the CF on
column J being "unresolved".
Either way, it's not difficult.
--
Biff
Microsoft Excel MVP
"Anna S" <Anna
wrote in message
...
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!
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko