Formula If([Date of Request])?
If date of request is less that today + 2 future days, I need my row to be red. The formula I am using is not working. Please advise.thx
Forum Discussion
Neither of these are working the way I have intended. I probably didn't explain well enough and have come up with something more...
If my [date of request] is more than 2-5 days prior to today, "yellow",
If my [date of request] is more than 6-10 days prior to today, "blue",
If my [date of request] is more than 11 or more days prior to today, "red"
Thank you for reviewing this again.
If my [date of request] is more than 2-5 days prior to today, "yellow",
If my [date of request] is more than 6-10 days prior to today, "blue",
If my [date of request] is more than 11 or more days prior to today, "red"
Thank you for reviewing this again.