FormatConditional formatting

set the value to your test value, and set either equal, less than etc, then
format as required.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Snowy" wrote in message
...
I would like to be able to highlight cells of results of functions that
achieve/do not achieve a specific value in a particular colour