Formula with color specifications

: I would like to create a formula with the following criteria:

: If cell D1=L, then shade all of Row 1 in red
: If cell D1=W, then shade all of Row 1 in blue

: I have tried using formulas and conditional formatting, but I'm able only to shade cell D1 with the specified colors, not the entire row.

: Any help with this would be greatly appreciated.

: Thanks,

: Bob

Hi Bobby

Select all of row 1 then choose "Formula is" and type: =$D$1=1 Set you color and your done.

Dave

: Hi Bobby

: Select all of row 1 then choose "Formula is" and type: =$D$1=1 Set you color and your done.

:
: Dave

Dave,

Thank you for your reply , the formula works great.
I just have a couple questions.
It seems to only work if I use a numeric value in the column (such as 1, 2 or 3, etc.), it doesn't seem to work with a text caharacter (L or W).
Also, the formula doesn't seem to work using a relative cell reference (D1=1), it only works using an absolute cell reference ($D$1=1), which makes it hard to copy into cells D3, D4, etc.
If you can help me with these two things that would be great. If not, I thank you for your help and your prompt reply, and I will use the formula as is.

Thanks again,

Bob

: