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

M

Michelle Sheldon

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

Don Guillett

Have a look at conditional formatting.


--
Don Guillett
SalesAid Software
[email protected]
Michelle Sheldon said:
I am using a DAYS360 formula and I want the result to be returned in green
Click to expand...
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.
 
B

Bob Phillips

--

HTH

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

Michelle Sheldon said:
I am using a DAYS360 formula and I want the result to be returned in green
Click to expand...
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.
 
B

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)

Michelle Sheldon said:
I am using a DAYS360 formula and I want the result to be returned in green
Click to expand...
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.
 
Top