I have another odd formula i'm trying to figure out, but I think its a bit complicated.
1. I want a cell to automatically highlight itself if the following conditions are met.
a. If the date is within 3 days of the date inserted or past the date inserted into the cell
b. there is no entry in the cell to the right of the cell we want to highlight.
1. I want a cell to automatically highlight itself if the following conditions are met.
a. If the date is within 3 days of the date inserted or past the date inserted into the cell
b. there is no entry in the cell to the right of the cell we want to highlight.