I have a task list that has weekly and monthly tasks to accomplish. Lets say the tasks are listed in column A and column B is blank until I complete the task, at which point i put an X in the cell next to the task. I want column B to visually change color throughout the time period to warn me that I am getting close to the time that something needs to be done.
Let look at the weekly tasks first:
I want to know if I can conditionally format column B cells like this: If cell is blank (no X), monday and tuesday have no fill. Wednesday and thursday are orange, and friday is red. If the cell has an X, no fill regardless of day of week
Monthly would be:
If cell is blank (no X), days of the month 1-10, no fil. 11-20 orange fill, 21-30 Red. if the cell has an X, no fill regardless of day of the month
Any thoughts?
Bookmarks