dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
7
share rss forum feed


H2OuUp2
Happy to be here
Premium
join:2002-03-15
Oklahoma City, OK
reply to Grey Area

Re: [Excel] Automatically highlight expire dates that are 15 day

downloadDateRange.xlsx.zip 8,478 bytes
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