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

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

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