Hello Andrew,

define the name HasFormula with the value
=GET.CELL(48,INDIRECT("RC",))

(go to Insert/Name/Define... and enter HasFormula into field Names in
workbook and
=GET.CELL(48,INDIRECT("RC",))
into field Refers to)

then select for example your whole workbook (left mouse-click on upper left
cell of sheet), go to Format/Conditional Formatting, select Formula Is for
Condition 1 and enter
=HasFormula
into next field, push button Format and select Pattern and the green color,
for example)

All cells with formulas will appear with a green background now.

Other interesting parameters for the get.cell() function you might find at
http://www.sulprobil.com/html/get_cell.html

HTH,
Bernd