Look up "Conditional Formatting" in the Help files.

Also he
http://www.contextures.com/xlCondFormat01.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Jerry" wrote in message
...
I am using Office 2000 an wish to have the spreadsheet change the color
based
on the value of the cell. If a calculation goes below a value it should be
red. If the value goes above another value it should be green. Otherwise it
should be black. Can this be done?
--
Jerry Westphal