|reply to moh33rizgma |
Re: [Excel] Automatically highlight expire dates that are 15 day
It's not easy if you never did it before.
Depends what version of Excel you are using, but basically the important function you need is;
This gives you today's date in a cell. So if you have your expiry date in cell A1, the formula
Will tell you how many days are left until expiry.
If you add a column that has this in it for all your products, you can use the conditional formatting with two possible conditions;
=0 (less than or equal to zero) format in RED
=15 (less than or equal to 15) format in YELLOW
you might have to play around with what order you set the formats in, but that's the fun part!
H2OuUp2Happy to be herePremium
Oklahoma City, OK
| That is what the conditional format has in the example I attached. You don't have to add a column to have conditional format you can write the formula to point to the cell with the date.|
Now if you did want to have a column that gives you days you can write a formula in it to tell you the number of days past due, or days till the due date and you can conditional it several different ways.
I attached an updated data range file that shows the different ways you can use conditional formatting.
Just check it out and it won't be long until you will be coming up with different ways to use conditional formatting.
I intentionally referred to different elements to show examples how you can use cell values and formulas, though there are many different ways (some easier) to come up with the same results.
Hope this helps.
He is no fool who gives up what he cannot keep, to gain what he cannot lose. - Jim Elliot