Select B1:B100

FormatCFFormula is: =$A15

Format to red and OK your way out.

If you wanted to have a different # for each cell then individual cell setting
would be necessary.


Gord Dibben MS Excel MVP


On Sat, 28 Jun 2008 09:52:01 -0700, KCK wrote:

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