Macro failing at conditional formatting font colour

Hi there,

I've recorded a macro in Excel 2007 which opens a file then highlights columns I to CH, then applies conditional formatting so that if a cell has a value of <0, it applies a red font with pink fill colour. Here's the code:

Formula:

Please Login or Register  to view this content.

The problem is, when I run it, it fails and hitting debug takes me to the below lines, highlighted.

Formula:

Please Login or Register  to view this content.

If anyone could point me in the right direction it would be greatly appreciated.

Try this:

Please Login or Register  to view this content.

A couple of questions:
1. Is the worksheet protected in any way?
2. Do you have at least SP2 installed on your Office 2007?

I can't see why it wouldn't work then - it works fine in 2010 (using your original code also). Can you post a sample workbook that it fails on? (no data necessary)

Noting that your workbook is in xls format, I assume you are aware that since an xls file colour palette can only use 56 colours, you may not get the exact colour you specify.