#1
|
|||
|
|||
Conditional Formatting - color only dates contained in a range
Info:
Column A contains an ID# Column B contains a circle (Font: Wingdings, Letter: l) Column C contains a Start Date Column D contains a Finish Date Cell: S2 =TODAY() Cell: T2 is 10 Cell: U2 =WORKDAY(S2,T2) I am trying to set a formula for conditional formatting to do the following: IF [the date contained in column D] falls between S2 AND U2 THEN color the cells in column B yellow In otherwords, if a date falls between now and the next 10 business days, I want to color the cell in column B the color yellow. I currently have a conditional format formula set to color column B red if the date in column I is <TODAY(). I tried to set up the formatting for YELLOW to be: :Format only cells that contain Cell Value - Between - =D2>S2 and =D2<U2 Format Font - yellow But it doesn't seem to work. Any help would be appreciated. Thanks, E |
#2
|
|||
|
|||
Hi
Use the formula section of cond. formatting: =AND(D2>S2,D2<U2) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting - past due dates | namedujour | Excel | 1 | 06-27-2014 04:16 PM |
Conditional Formatting with Graded Color Scale | Texas_Steve | Excel | 4 | 09-25-2013 11:44 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 |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |