Color in Excel Formulas
 

How do I select a text color based on the contents of a cell. I would like to
have the results of a formula be red if it below a value and green if above
another value. Otherwise it should be black. Can this be done?
--
Jerry Westphal

Hi
see: 'Format - Conditional' format for this

--
Regards
Frank Kabel
Frankfurt, Germany
"Jerry" schrieb im Newsbeitrag
...
How do I select a text color based on the contents of a cell. I would like
to
have the results of a formula be red if it below a value and green if
above
another value. Otherwise it should be black. Can this be done?
--
Jerry Westphal