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

Jerry

Check out the options in FormatConditional Formatting.

Gord Dibben Excel MVP

On Mon, 20 Dec 2004 10:59:04 -0800, "Jerry"
wrote:

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?

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