Hi, I'm trying to edit a spreadsheet where we have a column for 'date sent' (A)!!, and a column for 'date received back'(B).
I am trying to make it so that if a date is elapsed by 5 days, the cell turns orange. If the date passes by 10 days I would like it to turn red.
If possible, I would also like to make it so that if there is a date entered in column B, column A turns back to white.
Here is an example of how I would like it to look:
Thank you in advance!
Note: I am using Google Sheets, Not sure how much of a difference this makes.
I am trying to make it so that if a date is elapsed by 5 days, the cell turns orange. If the date passes by 10 days I would like it to turn red.
If possible, I would also like to make it so that if there is a date entered in column B, column A turns back to white.
Here is an example of how I would like it to look:
Note: I am using Google Sheets, Not sure how much of a difference this makes.
Last edited by a moderator: