Conditional format of field based on todays date and a future date
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!!!