condition formating
 

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.

condition formating
 

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



sb wrote:
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.

condition formating
 

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)

"sb" wrote in message
...
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.