|
|
||||||
|
#1
02-26-04, 03:46 PM
|
|
|
|
|
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? |
|
|
|
#2
02-26-04, 03:55 PM
|
|
|
|
|
Have a look at conditional formatting.
|
|
#3
02-26-04, 03:57 PM
|
|
|
|
|
--
HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Michelle Sheldon" <anonymous> wrote in message news:55f2 > 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. |
|
#4
02-26-04, 03:59 PM
|
|
|
|
|
Hi,
Format>conditional formating, should allow you to do this |
|
#5
02-26-04, 04:00 PM
|
|
|
|
|
Conditional formatting is what you want with less than or equal to
conditions. Test <=21 first, then <= 28, then > 28 |
|
|
| Similar Threads | |
| can I color true or false results differently in excel I want to identify the day of the week in my spreadsheet and have used... |
|
| Changing Background Color as a True/False Response I would like to change the background color of a cell in response to a FALSE condition in an IF statement in Excel2003. Consider a cell A1 containing the number 5. I would... |
|
| Win32_PrintJob not reliable and how to get paper size and color(true/false) Hi, I was looking around for a solution for monitoring printJob and be able to charge users for the jobs they send. I came to the WMI class Win32_PrintJob. But as I tested,... |
|
| Want to change the color of a true/false logical statement with i. Trying to change the color of the results generated from a if:then, true/false logical statement with in a formula. I would be happy if I could change the format of the cell... |
|
| How can I make a True or False statement a certain color when usi. I am using a > function and want my results that are greater to show up in green and results that are less than to be red. Is this possible? |
|
|
All times are GMT. The time now is 04:43 AM. | Privacy Policy
|
text color change if value is true, another color if value is false