Hi Andrew,

You can use a user defined function (see my formula.htm page):
But it must be in the same workbook not your personal.xls to work
in Conditional Formatting, though there is no harm in having it in both places.

Function HasFormula(cell)
HasFormula = cell.HasFormula
End Function

=hasformula(a1)

use the above in your conditional formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

If you need help to install a User Defined Function or a Macro see
http://www.mvps.org/dmcritchie/excel/getstarted.htm

alternative:
You can temporarily see which cells have formulas with Ctrl+A, Edit, GoTo,
[Special], Formulas, (check all: Numbers, Text, Logicals, Errors)
You could then use Format,cells, pattern to color the cells.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Andrew Heath" (delete) wrote in message ...
Hi to all fantastic Excel champions,

How do I get conditional formatting to change the format of any cell that
contains a formula?


Kind regards
--
Andrew 'The Ox' Heath
Brisbane, QLD
Australia