Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page hard formula needed hard formula needed
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 03-17-2016, 05:24 AM
xor xor is offline hard formula needed Windows 10 hard formula needed Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
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
  #2  
Old 03-17-2016, 10:06 AM
nfsmith nfsmith is offline hard formula needed Windows 7 32bit hard formula needed Office 2013
Novice
hard formula needed 		 
Join Date: Mar 2016
Posts: 8
nfsmith is on a distinguished road
Default Hard formula
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.
Attached Files
File Type: xlsx duration times.xlsx (12.0 KB, 10 views)
Reply With Quote
  #3  
Old 03-17-2016, 11:39 AM
xor xor is offline hard formula needed Windows 10 hard formula needed Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
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
Is it better now?
Attached Files
File Type: xlsx Duration_2.xlsx (13.8 KB, 13 views)
Reply With Quote
  #4  
Old 03-19-2016, 06:12 PM
nfsmith nfsmith is offline hard formula needed Windows 7 32bit hard formula needed Office 2013
Novice
hard formula needed 		 
Join Date: Mar 2016
Posts: 8
nfsmith is on a distinguished road
Default
That is perfect. thanks for the help
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complicated Formula Needed midgetmogalle Excel 14 01-29-2014 10:26 AM
hard formula needed Formula help needed Cosmo Excel 1 08-23-2012 11:50 AM
hard formula needed 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:35 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft