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

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!

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

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


"MaryatSHO" wrote:

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!