Allen Barbe
asked on
Annual Address Update
Hello,
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?
-Allen
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?
-Allen
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OddyWriter
Thank you as you completely understood what I required and it worked perfectly! Again, thank you for your time and effort!
-Allen
Thank you as you completely understood what I required and it worked perfectly! Again, thank you for your time and effort!
-Allen
To attach the file, click Attach File below your comment/question, browse to the file and then click Upload. A box will appear which needs to be completed with a basic description before clicking Submit.
With dates, I have often seen the theory applied the wrong way round. Dates are basically held as numbers in Excel so comparisons can be done just like ordinary numbers but need to decide what you are comparing.