1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Conditional Formatting/ Formula

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

Thread Status:
Not open for further replies.
Advertisement
  1. ChrisCawley

    ChrisCawley Thread 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. Keebellah

    Keebellah Trusted 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. ChrisCawley

    ChrisCawley Thread Starter

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

    Attached Files:

  4. Keebellah

    Keebellah Trusted Advisor

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

    Keebellah Trusted 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.
     

    Attached Files:

  6. ChrisCawley

    ChrisCawley Thread 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 :D
     
  7. Keebellah

    Keebellah Trusted 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. ChrisCawley

    ChrisCawley Thread Starter

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

As Seen On
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.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Solved Conditional Formatting
  1. Squashman
    Replies:
    5
    Views:
    355
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/957178

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice