Hi Jason
lol
I know we 'old Europeans' should use the dot as decimal delimter, etc :-)
Just as addition. If you want to use a string value for a date use the ISO
format
YYYY-MM-DD
This (should) works in all Excel versions

--
Regards
Frank Kabel
Frankfurt, Germany
"Jason Morin" schrieb im Newsbeitrag
...
Hi Frank
I didn't know there was anything outside the US :-)
Good point. I keep forgetting this is an int'l forum.
Jason

-----Original Message-----
Hi Jason
better to use
=$A1DATE(2004,12,24)
to make sure it will work also outside the US :-)

--
Regards
Frank Kabel
Frankfurt, Germany

Jason Morin wrote:
Let's assume col. A and any date after 12/24/2004:

1. Select col. A.
2. Go to Format Conditional Formatting
3. Select "Formula Is" on the drop-down
4. Insert:
=$A1"12/24/04"+0
5. Press the Format button and format as desired
6. Press OK twice

HTH
Jason
Atlanta, GA

-----Original Message-----
How do I get cells to automaticly highlight after a
specific date?
.


.