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.