J.Smith wrote:
It seems like a trivial thing, but I seem to be unable to locate a worksheet
function that allows me to determine, if a given cell contents is a formula
or a value.

Try the F5* Special route (options are available there)
*or click Edit Go to.. , or Press Ctrl+G

Press F5 Special Check "Formulas" OK
will select all formula cells on the sheet at one go
Then we could apply Format Cells Font tab (to taste)

Similarly, we could also select the constants:
Press F5 Special Check "Constants" OK
then apply format to taste, etc ...

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---