View Single Post
 
Old 12-24-2010, 10:37 AM
Kimberly Kimberly is offline Windows 7 Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Did you successfully find Conditional Formatting?

If the cell where you want to type the date to highlight is A1, and the cell that is the upper left corner of the cells that contain dates is C5, then select the range (C5 through whatever) and use this formula in the Conditional Formatting dialog box:

=C5=$A$1
Reply With Quote