Conditional Formatting if cell contains formula

[brokenbiscuits]

Hi guys

Is the above possible? I have a spreadsheet which contains forecasted work volumes for future weeks, which are then overtyped week by week with actual values.

I was wondering if there was a way to use conditional formatting to change the font color once the formulae were overtyped with values.

Cheers

BB

[NBVC]

There is a way explained in this link: Highlight Cells With Formulas

Would that help?

[brokenbiscuits]

This looks perfect, thank you. Amazing stuff.

[Doru]

Hi, thanks, it works fine even with the Excel 2007.
Howevr, there is a slight inconvenience - as it refers to Excel 4.0 function stored in defined ames, the workbook has to besaved as a macro-enabled workbook (instead as plain xlsx file)