I set up conditional formatting with the goal of checking cell dates. The formatting is supposed to gauge and show how quickly a date is coming up to complete a task.
Below is how I set this up. What I did was use TODAY() thinking that would pull the cell value. What it is doing is using the current date instead of the cell date. How do I use the cell’s date instead? If the cell value of I12 is 6/3, how does that compare to today? Are we x days before or after?
You can see from the green outlined cells a specific date and then the other green outline represents the date ranges I am after. The 6/3/2021 date should not have any highlighting at all since the date passed.
Any ideas?
