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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Taylor" wrote:
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?