Are you wanting to do this in code? My earlier post presumed not - that you
wanted to do it from the keyboard.

"Mark" wrote:

Hi,

Could you tell me how i can apply conditional formatting rules to all sheets
in a excel 2007 workbook?

Also, can you copy rules from file to file?

Thanks,
Mark