filling conditional formatting

[Guest]

I want cell A1 to be the color red if B1=1 and yellow if B1=2. I have figured
out how to do this with conditional formatting, but how do i fill the
conditional formatting for A2-A100 without creating a conditional format for
each a cell?

 

[Guest]

2 ways ..

1. Simply use the format painter.

Select A1 which contains the CF, click on format painter (brush icon). This
copies the formatting. Then just select A1:A100 to paint/"paste" the
formatting (inclusive the CF formatting) to the range.

2. Set and apply the CF to the range at one go (my preference)

Select A1:A100 (A1 active), then apply the CF using "Formula is:"
Condition 1: =B1=1
Format > Red fill
Condition 2: =B1=2
Format > Yellow fill
OK out