Excel 2003
I enter a series of dates in B3:B13 - Cells formatted as dates [ 3-Apr-10 ]
I have a mini calendar in Q7:W12- Cells formatted as dates, but only showing
date [ 1, 2, 3, etc. ]
I would like to use Conditional Formatting to look at the range of dates in
B3:B13 and highlight all the cells that contain a date in the mini calendar.
I have been successful with the current date highlighting in the mini
calendar with:

Cell value is | equal to | =TODAY()

Any help would be appreciated. Thanx!

Try this...

Select the range B3:B13
Select the Formula Is option
Enter this formula in the box on the right:
=COUNTIF($Q$7:$W$12,B3)
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"BWR_Rick" <(E-Mail Removed)> wrote in message
news:7B3934D3-9D3B-426C-8405-(E-Mail Removed)...
> Excel 2003
> I enter a series of dates in B3:B13 - Cells formatted as dates [
> 3-Apr-10 ]
> I have a mini calendar in Q7:W12- Cells formatted as dates, but only
> showing
> date [ 1, 2, 3, etc. ]
> I would like to use Conditional Formatting to look at the range of dates
> in
> B3:B13 and highlight all the cells that contain a date in the mini
> calendar.
> I have been successful with the current date highlighting in the mini
> calendar with:
>
> Cell value is | equal to | =TODAY()
>
> Any help would be appreciated. Thanx!

You can also try to use this formula at your conditional formatting's formula.
=SUMPRODUCT(--(Q7=$B$3:$B$13))>0

If not clear, you can see the details at http://smartusemicrosoftoffice.blogs...ate-range.html.

Lee Li Fong
http://smartusemicrosoftoffice.blogspot.com/

---
frmsrcurl: http://msgroups.net/microsoft.public...g-Date-Range,2