Circle values that don't match any of the ones in a dropdown list
Posted
by
Robert4242
on Super User
See other posts from Super User
or by Robert4242
Published on 2012-11-06T02:43:07Z
Indexed on
2012/11/06
5:06 UTC
Read the original article
Hit count: 548
I created a dropdown list with values and assigned them to one of the columns in a table.
When I changed a few, then changed the name of items in the list and removed some I accidentally did some key combination somewhere around Ctrl+Z or Ctrl+Y and Excel highlighted cells in the table that had a value not on the list.
The highlighting looks like a red oval around each such cell. How can I toggle it on and off?
© Super User or respective owner