Conditional Formatting on expiration dates.

**xceldummie** · 06-21-2011, 09:55 AM

Hello...

I have a spreadsheet where we track our contractor's Worker's Comp and General Liability insurance certificate expiration dates. I want the expiration date to highlight in red if it is expired and to highlight in orange if it will expire within 30 days or less.

I have attached a testing sheet similar to what I'm working on. The F column has the dates that need to highlight. Please help! Oh, and I have MS Excel 2010. Thanks for any help you can offer!

**sweep** · 06-21-2011, 10:20 AM

Hi,

Please see amended attachment

**akur01** · 11-11-2013, 05:25 PM

Any idea how to view the conditional formatting in MS Office 2010?

**timbo1957** · 06-21-2011, 10:28 AM

See Attached.

**xceldummie** · 06-21-2011, 11:06 AM

Thanks! That's exactly what i needed. May I ask how you did it?

NEVERMIND, SWEEP'S VERSION WAS EXACTLY WHAT I NEEDED. THANKS SO MUCH FOR YOUR HELP GUYS!!!! I REALLY APPRECIATE IT!

**timbo1957** · 06-21-2011, 11:22 AM

If you select one of the cells that are formatted and click Format and select Conditional Formatting (Windows XP) you will see the conditions that I put in.

Basically you are formatting the cell so that if the contents are < than TODAY() you want the background colour to be red.

Then you add a second condition which says if the contents of the cell are less that TODAY()+30 you want the background colour to be orange.

Not sure where this sits in Office 2007 or 2010.

Glad to be able to help.

**arlu1201** · 11-12-2013, 01:13 AM

akur01,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.