How to Circle Invalid data in Excel ?

Posted on by

Excel displays a red circle around any cells that contain invalid data. All cells that don’t meet their data validation criteria are circled.

This is most useful when checking for incorrect ID numbers, phone numbers, etc.