Using conditional formatting you can.
Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help
--
HTH
RP
(remove nothere from the email address if mailing direct)
"williamw" wrote in message
...
I have entered an "if" statement in excel to return true or false . Can I
additionally change the cell fill colour automatically based on the
Returned
value eg True - blue or False - red
|