Under Home, select conditional formatting. Click new rule. Select “format only cells that contain.” Change cell value “equal to” and enter date of interest. Click format, select fill tab, and choose a color. Click Ok. Click conditional formatting again and select manage rules. change formatting rules from current selection to this worksheet. Select button next to applies to and select area of worksheet you want the rule to apply to. Click apply, then ok, and this should work.