Excel 2003

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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?
 
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.
 
Thanks Dave
--
Andrew


Dave said:
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.
Click to expand...
 
Back
Top