Paul_Hossler
03-28-2009, 05:26 PM
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
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