Excel 2003

[Andrew]

I have a result from a formula and now want a rule that if the result i.e.
=/< 5 days the cell must be "Green" if the result is > 5 days the cell must
be "Red". How do I create this?

 

[Dave]

Hi Andrew,
Use Conditional Formatting.
Select the cell, then Format > Conditional Formatting
Set first dropdown to "Cell Vaue Is"
Set second dropdown to "less than or equal to"
Enter 5 into the third window.
Click on Format and select red, then OK
Click Add
Repeat for the second condition:
Cell Value Is, greater than, 5
Format green
OK, OK
Regards - Dave.

 

[Andrew]

Thanks Dave
--
Andrew

Hi Andrew,
Use Conditional Formatting.
Select the cell, then Format > Conditional Formatting
Set first dropdown to "Cell Vaue Is"
Set second dropdown to "less than or equal to"
Enter 5 into the third window.
Click on Format and select red, then OK
Click Add
Repeat for the second condition:
Cell Value Is, greater than, 5
Format green
OK, OK
Regards - Dave.