Perhaps just another interp / play ..
Assume the calendar dates are in B51:B105
(From: 01-Jan-05 till 24-Feb-05)
And you have a list of 5 dates in say, B107:B111
07-Jan-05
09-Jan-05
11-Jan-05
23-Feb-05
20-Feb-05
Select B51:B105
Click Format Conditional Formatting
Under Condition 1, put it as
Formula is:
=ISNUMBER(MATCH(B51,$B$107:$B$111,0))
Click Format button Patterns tab Yellow OK
Click OK at the main dialog
The above will colour the 5 cells within B51:B105
with dates matching those within B107:B111
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Nat" wrote in message
...
This is probably a really simple question, but I can't get my head around
it.
In one Column I have a list of dates, and above it I have a calendar
template. I want to set up conditional formatting so that if a date
appears
in the list, the cell of that date on the calendar is highlighted yellow.
I've used:
=$B$51:$B$105=DATE(2005,1,7)
I put this in the cell of 7th Jan 05 (not US format) This worked great
and
the cell was highlighted. But when I try it with any other date after 9th
Jan 2005 it fails!
ie.
=$B$51:$B$105=DATE(2005,2,4) - This formula to highlight on 4th Feb
doesn't
work!
What am I doing wrong?
All help is greatly appreciated!!
Thanks,
Nat