LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting:highlight row based on blank or non-blank c Nat Maxwell Excel Worksheet Functions 3 May 14th 23 07:43 PM
Highlighting rows/columns is there a way to darken the highlight? Jerri Lynne Excel Discussion (Misc queries) 1 February 23rd 08 08:39 PM
How to Highlight Two Rows With Two Columns of Duplicate Values JSteph Excel Worksheet Functions 1 December 12th 07 01:59 AM
conditional formatting:highlight row based on blank or non-blank c Nat Maxwell Excel Discussion (Misc queries) 2 November 30th 05 10:30 PM
Isolate rows based on highlight (Excel 2003) Alcide Excel Worksheet Functions 2 April 21st 05 05:40 PM


All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"