format painter wont paint

  • Thread starter Thread starter danman
  • Start date Start date
D

danman

I USED THE CONDITIONAL FORMAT OPTION..LOOKS OK IN CELL C5......HOWEVE
WHEN I PAINT OVER THE REST OF THE ACTIVE AREA...IT PLACES THE SAME C5
FORMAT STATMENTS IN THE CONDITIONAL FORMAT LINES...IT DOES NO
INCREMENT THE STATEMENT VARIABLES TO C6, C7 ETC

ANYTHING I AM MISSING?

THANK
 
First kill the caps

Second kill the $ signs in the cond format statement as they are locking your
condition to the cell you referenced
 
Hi
probably a problem with absolute/relative references. How dows your
formula for cell C5 in the conditional format dialog look like. Maybe
something like
=$C$5>some value

if yes change this to
=C5>some value
and copying the format should work
 
Back
Top