Conditional Formatting Copy down Rows

[SMac]

Ok, I have used Paste Special format and the paint without the results I want.

I have the following example of two rows:
High Low Sample1 Sample2 Sample3 Sample4
0.25 -0.25 0.14 0.25 0.3 -0.35
0.35 -0.35 0.28 0.4 0.35 -0.5

The conditional formating is on the Sample cells
If Sample1 is greater than High turn red & If Sample 1 is less than Low turn
red - works great when in the first row copy/paste special or painter brush
for next row then is still looking at A2 & B2 not A3 & B3 so I take out
absolute signs and works for Sample1 messes up for the other samples because
it just moves it over.

I have about 100 rows and 20 columsn I need this conditional formating on
and it could grow - any fast copying way?

Thanks!!!

 

[bpeltzer]

Sounds like you changed from an absolute reference ($A$1) to a relative
reference (A1); try a mixed reference ($A1) instead. This should hold the
column reference fixed and vary the row reference as you autofill.
HTH. --Bruce

 

[SMac]

HA!
This worked, never thought of mixing them.

Thanks a bunch!
Stacey