I understand the concept

would like to know if there is a way to "copy" down the conditional format
and have it pick up on the subsequent cell that needs to be looked at for the
condition

ie

cells a1 thru A100 all have values between 1-10

cells B1 thru B100 need to be red if the corresponding A1 thru A100 value
exceeds a given value(say 5)

is there a way i can have this conditional format apply globally....or do i
have to format each cell(B1 to B100) individually



thanx

kck