7 Replies Latest reply on Feb 10, 2011 7:09 AM by pademo57

    Conditional format of field based on todays date and a future date

    pademo57

      Title

      Conditional format of field based on todays date and a future date

      Post

      Yes, if you can't tell from the title, I am a newbie.  Here is my problem:

      We have a record which shows a date, for example,  Due_Date = March-31-2011.

      I have a list that comes up every day with all these Due Dates.

      I would like to have the field turn Yellow if I compare the Due Date to today's date and there is less than 30 days between them.

      I would also like the field to turn Red if the Due Date and today's date is less than 10 days between them.

      For the life of me, I can't figure out how to do this, any and all help greatly appreciated!!!