How do I colour the result of a function in excel?

S

Snowy

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
 
B

Bob Phillips

Format>Conditional 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)
 
A

Alex Delamain

Look at conditional formatting on the format drop down.

This will enable you to set a format based either on an absolute valu
(e.g. if value in cell is greater than 100 then put the text in red) o
on a formula (e.g. if the value in the cell is more than 20% higher tha
in A1 put it in red)
 
Top