Color in Excel Formulas

J

Jerry

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?
 
G

Gord Dibben

Jerry

Check out the options in Format>Conditional Formatting.

Gord Dibben Excel MVP
 
R

RagDyer

Look up "Conditional Formatting" in the Help files.

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

HTH,

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

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?
 
Top