How to format an entire row a certain color depending on the value in a cell?

[slipandfall]

Howdy,

Can anyone of you excel gods help me with the following?

I have a small spreedsheet (excel 2003) set up like the following to help me
keep track of my music collection:

A B C
D
1 Title Artist Year
Format (1=LP, 2=CD, 3=Tape)
2 HardDaysNight Beatles 1966 1
3 Crossroads Eric Clapton 1985 2


I would like to know at a glance by color coding, what the ratio of
LPs,CDs,&Tapes make up my collection.

I've figured out how to conditionally format D2's & D3's cells to
automatically change background color depending on the value I type into
them. ie 1=green, 2=blue, 3=yellow.

My question is, what do I need to do to get the entire row of that
particular cell to change background color as well? Ultimately, I would like
A2,B2,C2,D2 to be background = green and A3-D3 background=blue

I've tried to play with the "format painter" tool but it only seems to paste
the font alignment from one cell to the next not the conditional formating
that goes with it.

Any suggestions?

-thanks

 

[Biff]

Hi!

Try this:

Assume your table is in the range A2100.

Select that range, A2100
Goto Format>Conditional Formatting
Condition 1
Formula Is: =$D2=1
Click the format button
Set the background color to GREEN
OK
Click the Add button
Condition 2
Formula Is: =$D2=2
Click the format button
Set the background color to BLUE
OK
Click the Add button
Condition 3
Formula Is: =$D2=3
Click the format button
Set the background color to YELLOW
OK out

Biff