I need help with a macro for conditional formatting cells using the number
format. I can get it to work for bold font or cell color but not number
format when I am recording it. For this I recieve the following when
recording:

ExecuteExcel4Macro "(2,1,""#,##0.00_);[Red](#,##0.00)"")"


I tired re-writing it but without success. I tried recording it many
different ways. The macro sees this as an error.

Is Excel 4 a hidden macro?

is this a bug? If so how do I get around it?
--
Kathy