content_image/749678.jpg content_image/749679.jpg content_image/749680.jpg
The cells which contain the specified character(s) will now appear with the cell formatting which you selected. 

## A Date Occurring 

To highlight cells that contain a certain date or date range: 

1. Highlight the data range. 

2. Select Conditional Formatting . 

<img src='content_image/749678.jpg'>

3. Hover over the Highlight Cells Rules . 

4. Select A Date Occurring  to open the Date Occurring dialogue box. 

<img src='content_image/749679.jpg'>

5. Select the date or date range that you’re looking for. 

6. Select the type of cell formatting. 

7. Select Ok . 

The cells which contain the specified date or date range will now appear with the cell formatting which you selected. 

## Duplicate Values 

To highlight cells that contain either duplicate or unique values: 

1. Highlight the data range. 

2. Select Conditional Formatting . 

<img src='content_image/749680.jpg'>

3. Hover over Highlight Cells Rules . 

4. Select Duplicate Values  to open the Duplicate Values dialogue box. 

