Conditional Formatting Past Due Dates

[MLS Packer Lover]

Hello All:

I have searched message boards and can't find the same issue I am having. I am setting up a spreadsheet in Excel 2007. I work in engineering parts and we have to occasionally issue Temporary Work Instructions to the plant. We issue them and they usually expire in 30 days, but some expire sooner. (You'll see that in Colum G.)

Column F = Issue Date
Column G = Expiration Date.

I used a formula for column G so that it added either 7, 14, 30, 31 days to the date in Column F. What I need is for Column G to be highlighted when it expires, so that the work instruction can be removed from the floor.

I understand how to do Conditional Formatting, but since the dates vary, is there a way that I can easily set it up by highlighting Column G (Expiration Date) so that it it will automatically highlight once it is exp, without me going in and applying the rule to the whole column and not do it row by row?

Any help is greatly appreciated.

Thanks!

Mich

[6StringJazzer]

Try attached

[MLS Packer Lover]

6StringJazzer - Thank you VERY much! That looks perfect!!

Mich

[shifty1]

Okay I've been mexxing around with this for days with no luck. the spreadsheet i need is pretty simple but the expiration periods are killing me and i cant seem to get this to work.

Heres what I am trying to do:

Columb A: just numbered from 1-200
Columb B: employee names
Columb C: certifiaction date
Columb D: (heres where im having trouble)... I am trying to make columb D highlight
orange if 90 days from expiration,
yellow if 60 days from expiration,
and red if it is "within or past 30" days of expiration of the certification date or a fourth color if expired, i dont really care at this point... I have been trying this for days with no success. if anyone can help I would be greatful.

The certification is good for two year and that in itself is killing me as well.

PLEASE HELP ME OUT,

thanks.

[MLS Packer Lover]

When will the certifications expire? I'd need to know that before I can help you.

[usafmeinweg]

Shifty1,

See attached. It should be what you are looking for.

[MLS Packer Lover]

Here you go. Let me know if it's what you're looking for.

Mich

[royUK]

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.