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!

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:

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!

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!