I have a spreadsheet that has many columns, essential I have a header
for a group of three columns which is a merge of three column cells to
make one cell and has a date (01/01/08) in it formatted to "mmm/yy". I
want to apply a conditional format tot the merged cells within the
range that has the current month in it. here is an example of what I
have:

Starts in column E2 on Row 2
(I want to highlight the merged cells that equal the current month
based on date in $A$1
‚€€€€€€€€€€€€€ˆ€€€€€€€€€€€€€ˆ€
� Jan-08 � Feb-08 �-------
Dec-08
†€€ˆ€€€€ˆ€€€€€Š€€ˆ€€€€ˆ€€€€€Š€
�Hrs�Emps �# Jobs �Hrs�Emps �# Jobs �
„€€‰€€€€‰€€€€€‰€€‰€€€€‰€€€€€

Thanks, sorry about the crude drawing. but wanted to make sure it was
understood.