Need row to turn yellow if date received is at least 2 days in the past

noclue

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!

Nic Larsen

Add a helper column to calculate your days with this formula: =TODAY() - [Date Received]@row

Then you can use conditional formatting to make a row change based on # of days and your status column.

Kimberly Loveless

To turn the entire row yellow/red you would need to set up some conditional formatting rules. You can do this by selecting the gray/white grid icon in the top bar. Then enter the conditions for each. You can change the background color or the font color of the entire row that meets those criteria.

noclue

Thank you. I know how to use conditional formatting but I can't find a way to make it turn yellow if the date received is AT LEAST 2 days past due. So anything more than two days late would turn yellow and more than 3 days last would turn red.

Nic Larsen

Add a helper column to calculate your days with this formula: =TODAY() - [Date Received]@row

Then you can use conditional formatting to make a row change based on # of days and your status column.

noclue

Thank you, Nic. That worked!