Excel for Data Analysis and Visualization

Find errors, conditional formatting and data validation

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

GOTO Special can also help you find cells that have not been copied correctly or contain features that cannot be seen on the cell e.g. conditional formatting and data validation.

Find Inconsistent Copies of cells

GoTo Special

You can do a similar thing with column differences.

Find Conditional Format and Data Validation cells

If you choose to look for all Conditionally Formatted cells it would result in the following. So these cells have some form of conditional formatting.

GoTo Special

To see the full course contents click here.

0 of 141 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop