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