6 month conditional formatting

bbutl027 · #1 12-11-2016, 01:27 PM

I am trying to do this one by 180 days.

Yellow= after 150 days I was using =TODAY()+150
Red= after 180 days I was using =TODAY()+180

Green= between date taken and 150 days
Red= If blank

I have only played with the yellow and red right now I can't get them right I have messed with them a little.

xor · #2 12-11-2016, 11:31 PM

Take a look at the attached.

bbutl027 · #3 12-12-2016, 06:27 AM

No quite what i am looking for I am looking for the date to turn colors without the day count in there.

gebobs · #4 12-12-2016, 08:50 AM

The day count is a calculation. Use that in the CF equation instead.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting	dayperson	Excel	1	02-23-2016 09:07 AM
Help with if and conditional formatting	piper7971	Excel	11	06-10-2015 12:07 AM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Conditional Formatting	jdc15371	Excel	2	06-26-2014 06:34 AM
conditional formatting	otuatail	Excel	1	06-06-2012 05:07 AM