In this session we can about how to circle invalid data in excel. The data Validation part is up to you.
In this tutorial we took a simple validation to for the demonstration.
You may want to use the data validation tools to check your worksheets for incorrect data that may cause inaccurate calculations or results. Cells that contain invalid data appear with a red circle around them so that you can easily find and correct any problems.
Here goes the step-by-step tutorial on how to circle invalid data.
1. Select the data range
2. Click on validation and set your validation rule
3. Click on data validation drop-down
4. Select “Circle Invalid Data”
Done.
Remember you can only circle 255 invalid data and these circles will not print.
#exceldatavalidation #rowsandcolumnsbyalfan #exceltricks
