hi
don't use "cell value". use "formula is"
formula is.....=A25.....pick your format.
copy down.

regards
FSt1

"KCK" wrote:

sorry ...this is not clear........the conditional formatting is drop down
menu...there is nothing to put into cell B2

in the conditional fomatting window (for cell B2)...i can put in "cell
value", "greater than" and then point to cell A2

but when i copy the cell down....all cells are lookin at A2 to meet the
condition and change colour


I can forward file to u to see what i have done if you like


thanx

kck

"FSt1" wrote:

hi
conditional formating can be copied down. in your formula just make sure
has relative references so that the paste will paste the corrosponding cell.
in B2 put as conditions =A25 then copy down.

Regards
FSt1

"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