Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight rows based on '1' or blank in all columns on a row
I have been playing with Excel 2007 conditional formatting here for a
while with no progress, so I thought I'd turn here for help. I have a spreadsheet of patch numbers and the systems to which they've been applied. If the patch is applied a '1' is in the cell; if not the cell is blank: PHSS_35884 1 1 1 1 1 1 1 PHKL_33110 1 1 1 1 PHKL_38311 1 1 1 PHKL_34909 1 1 1 1 1 1 1 PHNE_32057 1 1 1 1 1 1 1 PHKL_37263 1 1 1 What I'd like to do is have the row highlighted (or color set) if not all the cells in the row are one (meaning the patch is not yet applied to all systems). Is this easily done? TIA, Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting:highlight row based on blank or non-blank c | Excel Worksheet Functions | |||
Highlighting rows/columns is there a way to darken the highlight? | Excel Discussion (Misc queries) | |||
How to Highlight Two Rows With Two Columns of Duplicate Values | Excel Worksheet Functions | |||
conditional formatting:highlight row based on blank or non-blank c | Excel Discussion (Misc queries) | |||
Isolate rows based on highlight (Excel 2003) | Excel Worksheet Functions |