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?
.
|