Excel Cell Formula to change color on a given day.

**jamy695** · 06-03-2013, 12:37 PM

Please refer to my spreadsheet for clarification on this. Many Thanks in advance.

**MarvinP** · 06-03-2013, 12:49 PM

Hi jamy695 and welcome to the forum,

This looks like a job for Conditional Formatting. Read http://www.contextures.com/xlCondFormat03.html for a lot of examples and the section on Highlight Upcoming Expiry Dates specifically.

I'd hate to give you the exact answer without you learning how to it yourself.

**Fotis1991** · 06-03-2013, 12:50 PM

Like this?

**jamy695** · 06-05-2013, 08:10 AM

Thanks So Much Fotis1991. You sir are a legend!

**Fotis1991** · 06-05-2013, 08:31 AM

! You are welcome.

I need to mention that the link that MarvinP provided is teaching you how to fish(in our case to teach you how you can use the CF).

He said:

..I'd hate to give you the exact answer without you learning how to it yourself.

This is correct and i agree 100%. To say the true i felt not good(sorry Martin) when i saw that.

Now it's up to you(as i gave you the fish and Martin teached you how to fish) for the next time!

Good luck.