condition formating

[Guest]

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.

 

[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

 

[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)