On Thursday, 14 August 2008 07:59:01 UTC+7, Jean-Marc wrote:
Is there a way (conditional formatting?) to apply a different format to cells
that contain a formula, as opposed to cells that have a directly entered
value?
The opposite is possible to the same end.
mark the cell range, whole sheet or sheets
apply conditional formatting
select "custom formular is"
enter =isnumber(A1)
select color

This will color code all fields with numbers added with the designated color and leave all cells with formular or text in standard color.