The cells which contain the specified character(s) will now appear with the cell formatting which you  selected.  To highlight cells that contain a certain date or date range:  The cells which contain the specified date or date range will now appear with the cell formatting which  you selected.  To highlight cells that contain either duplicate or unique values:  18  3. Hover over  Highlight Cells Rules . 4. Select  Duplicate Values  to open the Duplicate Values dialogue box. 1. Highlight the data range. 2. Select  Conditional Formatting . 7. Select  Ok . 6. Select the type of cell formatting. 5. Select the date or date range that you’re looking for. 3. Hover over the  Highlight Cells Rules . 4. Select  A Date Occurring  to open the Date Occurring dialogue box.  1. Highlight the data range. 2. Select  Conditional Formatting . A Date Occurring  Duplicate Values 