How to Highlight Month-end dates

[Santosh080]

Hello Friends

I have list of dates like this,

Dates
01-04-2011
23-04-2011
30-04-2011
12-05-2011
14-05-2011
26-05-2011
31-05-2011
02-06-2011
10-06-2011
13-06-2011
18-06-2011
23-06-2011
30-06-2011
07-07-2011
13-07-2011
31-07-2011
03-08-2011
03-08-2011
10-08-2011
12-08-2011
20-08-2011
25-08-2011
31-08-2011
22-09-2011
24-09-2011
28-09-2011
29-09-2011
29-09-2011
30-09-2011
08-10-2011
12-10-2011
13-10-2011
15-10-2011
20-10-2011
25-10-2011
29-10-2011
31-10-2011
02-11-2011
11-11-2011
16-11-2011
24-11-2011
28-11-2011
30-11-2011



i want to highlight only the month end dates of every month by using formula. Please help.

Thanks

 

[kevin9999]

Book1
	A
1	Dates
2	1/04/2011
3	23/04/2011
4	30/04/2011
5	12/05/2011
6	14/05/2011
7	26/05/2011
8	31/05/2011
9	2/06/2011
10	10/06/2011
11	13/06/2011
12	18/06/2011
13	23/06/2011
14	30/06/2011
15	7/07/2011
16	13/07/2011
17	31/07/2011
18	3/08/2011
19	3/08/2011
20	10/08/2011
21	12/08/2011
22	20/08/2011
23	25/08/2011
24	31/08/2011
25	22/09/2011
26	24/09/2011
27	28/09/2011
28	29/09/2011
29	29/09/2011
30	30/09/2011
31	8/10/2011
32	12/10/2011
33	13/10/2011
34	15/10/2011
35	20/10/2011
36	25/10/2011
37	29/10/2011
38	31/10/2011
39	2/11/2011
40	11/11/2011
41	16/11/2011
42	24/11/2011
43	28/11/2011
44	30/11/2011
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A44	Expression	=A2=EOMONTH(A2,0)	text	YES

 

[Santosh080]

thanks very much

 

[kevin9999]

thanks very much

You're welcome