More conditional formatting

[helenmeyer]

I also have another problem with conditional formatting. When I put the following formula in to determine which cells to format it then changes my N/A (from a previous conditional format) to that particular colour too.

For this I used the following formula:

=IF(AND(b1<=TODAY()-1642,b1>1),TRUE)

 

[Joe4]

If you have multiple Conditional Formatting rules, you need to place them in the correct order to ensure that the top priority one is applied.
You can rearrange the order by selecting the "Manage Rules..." option.
Note that there is also a "Stop If True" checkbox next to each rule.