My job requires me to update personnel addresses annually. I want to track each individual by placing a date in a cell and the conditional formatting in the same cell changes color according to the date (i.e. over 365 days would be red and under 365 days would be green). So I put conditional formatting in the example attached. The cell does the opposite of what I want it to do. Is there a formula/conditional format that can be utilized to show what I am requesting?