Hello,
I have a spreadsheet where I am tracking a project with different timelines, and I would like to figure out a conditional format to make it highlight certain cells based on the due date.
I would like these cells to get highlighted a certain color when the due date is next week. Perhaps I can have a few different colors depending on the day.
I have attached a spreadsheet with a simple example of two columns.
If the date in Column B is this coming Friday, I would like Column A to be Red.
If the date in Column B is next Friday, I would like Column A to be Yellow.
If the date in Column B is the following Friday, I would like Column A to be Green.
If the date in Column B happens to be further than 2 Friday's out, then I would want Column A to be Blue.
Regardless of the due date, though, I do want Column A to be highlighted if the cell in Column B is not blank; which based on the above, it would be Blue if it was far out in the future.
How can I do this?
Bookmarks