Microsoft Office Forums Conditional formatting using a formula that will result in different colors based on dates

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-28-2015, 06:30 AM
19z 19z is offline Conditional formatting using a formula that will result in different colors based on dates Windows 7 32bit Conditional formatting using a formula that will result in different colors based on dates Office 2013
Novice
Conditional formatting using a formula that will result in different colors based on dates
 
Join Date: May 2015
Posts: 2
19z is on a distinguished road
Default Conditional formatting using a formula that will result in different colors based on dates


I am attempting to create a tracker where there is a column with the STATUS. In that cell I will put a formula where it reads cell D3 and based on the current date, the color could be one of four different. Example of what I am trying to do: Say the date in cell D3 is 1 Jun 15. Based on todays date (28 May 15) the cell fill color would be RED. The color RED would show if the suspense date is from the actual suspense date to 5 days before that date. From day 6 to day 14, the color would show as YELLOW. There would be 4 total colors including one if the current date is AFTER the suspense date (then it would show as black).

The objective would have this worksheet continually change colors based on the current date as this is a running tracker.

The conditional formatting doesn't seem to allow me 4 different colors, so haven't found a formula that would cover this. Any and all ideas would really help. Thanks all..........
Reply With Quote
  #2  
Old 05-28-2015, 07:58 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional formatting using a formula that will result in different colors based on dates Windows 7 64bit Conditional formatting using a formula that will result in different colors based on dates Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Hi and welcome
I don't think there is a limitation to the number of colours.
Please post a sample sheet showing expected results - Thx
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #3  
Old 05-28-2015, 09:06 AM
19z 19z is offline Conditional formatting using a formula that will result in different colors based on dates Windows 7 32bit Conditional formatting using a formula that will result in different colors based on dates Office 2013
Novice
Conditional formatting using a formula that will result in different colors based on dates
 
Join Date: May 2015
Posts: 2
19z is on a distinguished road
Default

I was able to get the colors by using the conditional formatting and selecting "Format only cells that contain". Now the only thing I have not been able to figure out is I want to also add a conditional formatting to the same column that would change the color based on a selected text in another cell (the two options in this other cell are YES and NO). I figured it would be using the option for a formula (under conditional formatting) but no formulas seem to work. Any ideas?
Reply With Quote
  #4  
Old 05-28-2015, 11:39 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional formatting using a formula that will result in different colors based on dates Windows 7 64bit Conditional formatting using a formula that will result in different colors based on dates Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Please post a sample sheet - Thx
__________________
Please note I am not active on this forum anymore
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Perform calc in active cell then highlight based on formula result grexcelman Excel Programming 4 01-12-2015 11:00 AM
Conditional Formatting Dates Phil H Excel 6 12-08-2014 07:42 AM
Conditional formatting using a formula that will result in different colors based on dates Conditional Formatting Dates jake.harris5253 Excel 1 12-06-2014 10:59 AM
Conditional formatting using a formula that will result in different colors based on dates Conditional Formatting with Dates namedujour Excel 1 02-21-2013 03:42 AM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Frogggg Excel 1 10-25-2011 08:44 PM


All times are GMT -7. The time now is 05:40 AM.


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