condition formating

S

sb

I have more than 50 columns, how I can make each column condition is column
dependent ? instead do column by column. I try use the paste special , it
doesn't work, it just copy all formula over from the first column.
 
C

Carim

Hi sb,

If I understand correctly, make sure your initial formula does not
contain absolute references, and then just make a normal copy-paste ...

HTH
Cheers
Carim
 
B

Bob Phillips

You can do it by selecting all the data at the start, before setting up the
CF.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top