Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nat Maxwell
 
Posts: n/a
Default conditional formatting:highlight row based on blank or non-blank c

Does anyone know if, and how, is possible to use Conditional Formatting
feature to automatically highlight the whole row if a specific cell in that
row is non-blank (or blank)?
Thank you!
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: conditional formatting:highlight row based on blank or non-blank c

Yes, it is possible to use Conditional Formatting to highlight the whole row based on whether a specific cell in that row is blank or non-blank. Here are the steps to do so:
  1. Select the range of cells that you want to apply the Conditional Formatting to.
  2. Click on the "Conditional Formatting" button in the "Home" tab of the ribbon.
  3. Select "New Rule" from the drop-down menu.
  4. In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format".
  5. In the "Format values where this formula is true" field, enter the following formula to highlight the row if cell A1 is non-blank:
    Formula:
    =$A1<"" 
  6. Click on the "Format" button to choose the formatting options for the highlighted row.
  7. In the "Format Cells" dialog box, select the "Fill" tab and choose the color you want to use to highlight the row.
  8. Click "OK" to close the "Format Cells" dialog box.
  9. Click "OK" to close the "New Formatting Rule" dialog box.

Now, any row that has a non-blank value in cell A1 will be highlighted with the color you chose in step 7. If you want to highlight the row if cell A1 is blank instead, simply change the formula in step 5 to:
Formula:
=$A1="" 
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Breitenbach
 
Posts: n/a
Default conditional formatting:highlight row based on blank or non-blank c

highlight entire row a. select conditional formatting and do formula is
=isblank(a1)

adjust for your cell and row

hth,
Dave
"Nat Maxwell" wrote:

Does anyone know if, and how, is possible to use Conditional Formatting
feature to automatically highlight the whole row if a specific cell in that
row is non-blank (or blank)?
Thank you!

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default conditional formatting:highlight row based on blank or non-blank c

Hi!

Suppose you want to highlight all of row 1, A1:IV1, if cell E1 is blank:

Select row 1 by clicking on the row header
Goto FormatConditional Formatting
Formula is: =$E$1=""
Click the Format button
Select the style(s) desired
OK out

If you want to change the condition to highlight the row if the cell IS NOT
BLANK, just change:

Formula is: =$E$1<""

Biff

"Nat Maxwell" wrote in message
...
Does anyone know if, and how, is possible to use Conditional Formatting
feature to automatically highlight the whole row if a specific cell in
that
row is non-blank (or blank)?
Thank you!



Reply
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 Formating Based on Date Roy Excel Discussion (Misc queries) 5 June 7th 06 04:49 PM
Creating a conditional format for a cell based on another cell's v steve-o Excel Discussion (Misc queries) 2 October 26th 05 03:51 PM
Conditional Formatting Blank =white.. but 4 conditions Junior Excel Worksheet Functions 3 December 18th 04 08:32 AM
conditional formatting blank cell TREK5200 Excel Discussion (Misc queries) 1 December 6th 04 02:23 AM
Lookup with search range start based on position of last blank lin rcmodelr Excel Worksheet Functions 0 November 14th 04 06:32 AM


All times are GMT +1. The time now is 10:00 AM.

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

About Us

"It's about Microsoft Excel"