Need row to turn yellow if date received is at least 2 days in the past
I need a way to turn a row yellow if the date received is at least two days in the past AND status is "bid complete", also turn red if date received is at least three days in the past and status is "bid complete". I would prefer if there was a way to do 48 hours and 72 hours but if not, days will work.
I could not figure out how to do this with conditional formatting. I can add helper columns or flag/RYG balls, just need the end result to turn the row red or yellow. Thanks!
Help Article Resources
Check out the Formula Handbook template!