m27mitchell
New Member
- Joined
- Mar 29, 2016
- Messages
- 29
Hello, I'm trying to apply conditional formatting to cells that contain a formula that returns a date (deducting days from another cell that contains a date). I want to do the following, but it's not working. I wasn't sure if the reason it's not working may be because the cell that it's formatting contains a formula to return a date, in lieu of an actual date being typed directly in the cell.
- If date in the past - cell is red formula I am using is: =($N6<TODAY()-30)
- If date is within the next 2 weeks - cell is yellow formula I am using is: =AND($N6<TODAY()-14,$N6>TODAY()-31)
- If date is further than 2 weeks out - cell has no color (fill) formula I am using is: =($N6>TODAY()-15)
- If cell is blank - cell has no color (fill) using the "format only cells that contain blanks" option
Any idea on what I'm doing wrong? It's making some of the past dates yellow instead of red, and some red, etc.
- If date in the past - cell is red formula I am using is: =($N6<TODAY()-30)
- If date is within the next 2 weeks - cell is yellow formula I am using is: =AND($N6<TODAY()-14,$N6>TODAY()-31)
- If date is further than 2 weeks out - cell has no color (fill) formula I am using is: =($N6>TODAY()-15)
- If cell is blank - cell has no color (fill) using the "format only cells that contain blanks" option
Any idea on what I'm doing wrong? It's making some of the past dates yellow instead of red, and some red, etc.