Excel Excel-Conditional Formatting

Sep 27, 2010
Reaction score
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 ;-)

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question