text color change if value is true, another color if value is false

[Guest]

I am using a DAYS360 formula and I want the result to be returned in green font if the value is less than or equal to 21 days, orange font if the value is equal to or less than 28 days and red font if the result is greater than or equal to 28 days

Any suggestions?

 

[Don Guillett]

Have a look at conditional formatting.


--
Don Guillett
SalesAid Software
(e-mail address removed)

I am using a DAYS360 formula and I want the result to be returned in green

font if the value is less than or equal to 21 days, orange font if the value
is equal to or less than 28 days and red font if the result is greater than
or equal to 28 days.

 

[Bob Phillips]

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I am using a DAYS360 formula and I want the result to be returned in green

font if the value is less than or equal to 21 days, orange font if the value
is equal to or less than 28 days and red font if the result is greater than
or equal to 28 days.

 

[jedicris]

Hi,

Format>conditional formating, should allow you to do this

 

[Bob Phillips]

Conditional formatting is what you want with less than or equal to
conditions. Test <=21 first, then <= 28, then > 28

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I am using a DAYS360 formula and I want the result to be returned in green

font if the value is less than or equal to 21 days, orange font if the value
is equal to or less than 28 days and red font if the result is greater than
or equal to 28 days.