I have a spreadsheet that I have created a number of rules in.
I am tracking dates for expiry, and highlighting accordingly.
The trouble I am having is with highlighting dates that are within 6 months, or 180 days from TODAY(). (Only up to today(), not after).
The exact reason: I am tracking employees that have been with the company for 6 months or less, and highlighting hire dates green.
When I try to apply the formula =TODAY()-E3<=TODAY()+180, it highlights all cells, not just the dates within 180 days from TODAY().
Also, is there a way to flag names with highlighting when an expiry date is near? Right now, I have the cells that have expired highlight red, and the cells that will expire within 30 days highlight yellow. I would like to highlight employee names if they have the highlighting I've explained.
I appologize in advance if my explaination is confusing...I think this spreadsheet is melting my brain ;-)
THANKS FOR ANY HELP ON THIS!!
I am tracking dates for expiry, and highlighting accordingly.
The trouble I am having is with highlighting dates that are within 6 months, or 180 days from TODAY(). (Only up to today(), not after).
The exact reason: I am tracking employees that have been with the company for 6 months or less, and highlighting hire dates green.
When I try to apply the formula =TODAY()-E3<=TODAY()+180, it highlights all cells, not just the dates within 180 days from TODAY().
Also, is there a way to flag names with highlighting when an expiry date is near? Right now, I have the cells that have expired highlight red, and the cells that will expire within 30 days highlight yellow. I would like to highlight employee names if they have the highlighting I've explained.
I appologize in advance if my explaination is confusing...I think this spreadsheet is melting my brain ;-)
THANKS FOR ANY HELP ON THIS!!