Excel 2003
 

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

Excel 2003
 

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" wrote:

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

Excel 2003
 

Thanks Dave
--
Andrew


"Dave" wrote:

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" wrote:

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