Conditional formatting with color coding dates

**BlasphemousMusic** · 04-05-2011, 05:13 PM

I have a training spreadsheet for work. I want to, if possible, make this easier to track.

A1 on down are names of employees
B is grade
C- M are the training types

Now I have it set up under the training name ther date and I have all who are current on this training green. Anyone who is due training withing 6 months its yellow. Any training that is a year, or over due/not found are red.

What I would ultimately like to do is to have these color code automatically, if possible, instead of me having to look at every training type and date.

Is there any way to set up a formula using "Today's Date" and having it color code like the above said?

Hopefully its not confusing, if so, I'll screen shot it and show an example of what I have now.

Thanks in advance,
Jim

**Cutter** · 04-05-2011, 05:16 PM

That feature is called Conditional Formatting.

And the function to get today's date is TODAY(). Here is a link for it:

http://www.excelfunctions.net/Excel-Today-Function.html

Don't supply a screen shot - instead upload a small sample file that does not contain personal/private data.

**BlasphemousMusic** · 04-05-2011, 05:19 PM

I was going to delete all personal info on it, but how do I upload a small sample file istead?

**BlasphemousMusic** · 04-05-2011, 05:27 PM

Added example.

**Cutter** · 04-05-2011, 05:29 PM

When making a new post you can scroll down to the Additional Options area.

Click on the Manage Attachments button.

In the new window that pops up use the Browse button to locate your file. Double click on your file when you find it. Then click on the Upload button. Close that window and submit your post.

**BlasphemousMusic** · 04-06-2011, 10:27 AM

Added sample above. I did look at the TODAY formula and didn't see much on how to do it. It was moreso for how many days are between a certain date.

**Cutter** · 04-06-2011, 12:11 PM

The attached file has CF applied to cells C2:M10.

See if it does what you want.

**BlasphemousMusic** · 04-06-2011, 01:00 PM

Does exactly what I want! tyvm! Also, how do I apply this formula to my all ready created speadsheet?

Conditional formatting with color coding dates

LinkBack

Thread Tools

Rate This Thread

Display

Conditional formatting with color coding dates

Re: Question on formula for spreadsheet (dates)

Re: Question on formula for spreadsheet (dates)

Re: Question on formula for spreadsheet (dates)

Re: Question on formula for spreadsheet (dates)

Re: Question on formula for spreadsheet (dates)

Re: Question on formula for spreadsheet (dates)

Re: Question on formula for spreadsheet (dates)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions