hard formula needed

nfsmith · #1 03-17-2016, 04:10 AM

yes this is what im looking for the most part, but where you have 1,2,and 3s, I would like to have the date in the color coded cells, the "date" would be the above date minus the days on the right.

Can it also be set up to change based on what day you open it?

xor · #2 03-17-2016, 05:24 AM

Quote:

Originally Posted by nfsmith

yes this is what im looking for the most part, but where you have 1,2,and 3s, I would like to have the date in the color coded cells, the "date" would be the above date minus the days on the right.

See the attached.

Can it also be set up to change based on what day you open it?

It does so already. In conditional Formatting dialog you will see formulas like =(C$1-$B2)<=$A$1
and A1=TODAY()

nfsmith · #3 03-17-2016, 10:06 AM

thanks for the help!!! I still have a little trouble, getting the formula to work on the dates. I had to modify my form. I have attached the spreadsheet. the 3 front columns need to be added to gather, then subtracted from the date. then color coded.

xor · #4 03-17-2016, 11:39 AM

Is it better now?

nfsmith · #5 03-19-2016, 06:12 PM

That is perfect. thanks for the help

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Complicated Formula Needed	midgetmogalle	Excel	14	01-29-2014 10:26 AM
Formula help needed	Cosmo	Excel	1	08-23-2012 11:50 AM
Formula needed to merge 2 name lists into one	lcolson	Excel	1	06-11-2012 12:03 AM
Very simple formula needed!	nicholes	Excel	4	04-12-2012 08:28 AM
Excel formula needed.	Rod	Excel	1	08-03-2009 06:55 AM