-
Can you tell if a cell has Data Valdidation Circle?
Excel 2007 -- I have some data validation rules, and I turn on "Circle Invalid Data" to put the red oval about cells that are out of spec.
Q1. Is there any way to tell how many cells in a range have those red ovals?
Q2. Is there any way to prevent pasting from one range to another from overwritting the validation rules of the "To" range?
Any ideas greatly appreciated
Paul
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules