|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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.......... |
#2
|
||||
|
||||
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
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
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?
|
#4
|
||||
|
||||
Please post a sample sheet - Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
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 Dates | jake.harris5253 | Excel | 1 | 12-06-2014 10:59 AM |
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 |