How to conditionally format entire row from contents of one cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to format a whole row based on the contents of one cell.

Like this...

If D6 or D7, 9, 12, 30, etc. are filled with the letter "R", then I want
that whole row (i.e. 6, 7, 9, 12, 30) to be shaded red.

How can I do this using conditional formatting. I can get the particular
cell to shade red, but not the whole row...based on that one cell.

Thanks!
 
Try this:

Select the rows to be impacted, choosing Row_7 last.
(do that by holding down the [ctrl] key while you select the row number at
the left of the window)

From the Excel main menu:
<format><conditional formatting>
Formula is: =($D7="R")
Click the [format...] button and select the format to be used.
Click the [OK] buttons when done.

Note_1: If the current row is NOT Row_7, adjust the formula to reference the
current row number.
Note_2: the dollar sign ($) locks that part of the reference, so every cell
in that row will test Col_D.
Note_3: that CF formula is NOT case sensitive. If you need a case sensitive
method, use: =EXACT($D7,"R")


Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Back
Top