Thread: [Solved] hard formula needed
View Single Post
 
Old 03-17-2016, 05:24 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Quote:
Originally Posted by nfsmith View Post
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()
Attached Files
File Type: xlsx Date_Minus_x_2.xlsx (10.2 KB, 14 views)
Reply With Quote