Excel Excel-Conditional Formatting


Joined
Sep 27, 2010
Messages
1
Reaction score
0
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!!
 
Ad

Advertisements


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

Top