Conditional Formatting specific month from a date range

[joeyjee]

Hi, can anyone help me with conditional formatting?

I want to highlight red for the month where the promotion will end. My problem is I do not know how to set conditioning where they have different promotion end date, as shown below. Say for example, customer A promotion ends at 31/7/2013, so Jul-13 will be highlighted as red, same for customer B, C and D. Please help, thank you.

Customer Promotion Start Promotion End Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13
A 1/1/2013 31/7/2013
B 1/1/2013 31/12/2013
C 1/2/2013 31/11/2013
D 10/1/2013 31/10/2013

[JBeaucaire]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[ramananhrm]

Please try this file.

[GOWTHAMRAJ]

Yes exactly what I'm looking for ............ Thanks for quick turn around time

[GOWTHAMRAJ]

But here only end day is highlighted .... I need to have highlighted from start to end

[GOWTHAMRAJ]

Pls help for this

[JBeaucaire]

Change the conditional formatting formula to:

=AND(EOMONTH(D$1,0)>=EOMONTH($B2,0),EOMONTH($C2,0)>=EOMONTH(D$1,0))