# Solved: Conditional Formatting/ Formula

Discussion in 'Business Applications' started by ChrisCawley, Oct 19, 2010.

Not open for further replies.
1. ### ChrisCawleyThread Starter

Joined:
Sep 16, 2010
Messages:
39
Hi guys i am back
I am using 1 formula (listed below) to help me with calibration reminders but after having a discussion with my boss she would like to have the date show up in color and not wording.
=IF(DAYS360(TODAY(),S5+90)>45,S5+91,IF(DAYS360(TODAY(),S5+90)<=0,"PastDue",IF(DAYS360(TODAY(),S5+90)<45,"Due")))

She does not want to see PastDue or Due, only for the date to show up in the colors i have selected using conditional formatting.
Example: Calibration Date Calibration Due Date
8/5/2010 11/3/2010 <----- does not show up using the formula above but she would like to see the date instead.

I have =SUM(S5+92) to automatically change with a calibration date has been entered to show up in calibration due date. =IF(AF5>45, "OK", IF(AF5<=0, "OVERDUE", "DUE")) is another formula that i was playing with to help with calibration reminders. =INDIRECT("AG"&ROW())="Due" is the conditional formatting formula that i used to have the date change colors.

If there is a possible way to have this all together that would be great. Let me know what you guys think i should/can do.

Chris

2. ### KeebellahTrusted Advisor

Joined:
Mar 27, 2008
Messages:
6,608
First Name:
Hans
I think that in this case a (picture = sample sheet) tells more than a thousand words . . .
You want a stoplight report?

3. ### ChrisCawleyThread Starter

Joined:
Sep 16, 2010
Messages:
39
Please see attached sample. Let me know if you need anything else

File size:
18.5 KB
Views:
40
4. ### KeebellahTrusted Advisor

Joined:
Mar 27, 2008
Messages:
6,608
First Name:
Hans
I'll get back to you, let me look and see

5. ### KeebellahTrusted Advisor

Joined:
Mar 27, 2008
Messages:
6,608
First Name:
Hans
See your sample returned, I didn't do anything special, just some conditional formats based on your own results and hid all the columns after the date.

I also show what I mena with a stoplight report.

See what you can do with it.

File size:
21.5 KB
Views:
81
6. ### ChrisCawleyThread Starter

Joined:
Sep 16, 2010
Messages:
39
Thanks for the reply, it's pretty much what i was doing but just added the stoplight affect which i like. Again you guys are the best

7. ### KeebellahTrusted Advisor

Joined:
Mar 27, 2008
Messages:
6,608
First Name:
Hans
Well Chris, thanks for the update.
Don't forget to press the Solved button.

8. ### ChrisCawleyThread Starter

Joined:
Sep 16, 2010
Messages:
39
Thanks i didn't see the button but i do now thanks again.

As Seen On

### Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

over 733,556 other people just like you!