Circle Invalid Data
Description of Example
In the figure below, valid entries are defined when it's greater than or equal to 80. The objective is to encircle all data below 80.
How is it done
The first step is to select the data, then go to Data > Data Validation… A small window will come out and a validation criteria can be set. In this particular example, we will allow "Whole number" which are greater than including 80. Press Ok and the condition is set.
After defining the criteria, go to Data > Data Validation > Circle Invalid Data. Circles will then appear around cells that contains incorrect entries.
Excelcrib was founded in November 2017 by Garry, a Microsoft® Office Excel® (MS Excel) enthusiast with background in engineering. He's been using MS Excel for more than 15 years in practice with specialty in VBA.