Forum Discussion
Solved
conditional formatting not applying all rules?
I'm attempting to have my cells change color based on how far away the date is from today. Most of it is functioning as expected but for some reason, the rule for between 7 and 14 days is not applying the color orange. Photos attached. Quite confused as the others work fine.
Hi,
For that rule you have condition
=TODAY+14
which obviously returns an error. Please change on
=TODAY()+14
4 Replies
What are your other rules? Perhaps you may attach sample file to check it.
Sample file!
Hi,
For that rule you have condition
=TODAY+14
which obviously returns an error. Please change on
=TODAY()+14
