Color of Validation Circles?
 

Excel 2003 ... I have a large Worksheet where some cell patterns are RED from
Conditional Formatting ... Some of these cells also include "invalid" data
(outside of Validation limits) ...

Above said ... When I circle the "invalid" data using the Audit Tool Bar ...
the "Validation Circles" are also RED & mostly obscured by the RED cell
patterns (Conditional Formating)

Bottom line ... I wish to change the color of the "Validation Circles" ...
Can this easily be done? ... If so ... How? ... Thanks ... Kha

Color of Validation Circles?
 

I doubt if you can change the default auditing circle color.

Have you tried just changing the CF color to something that does not conflict
with the circles?


Gord Dibben MS Excel MVP

On Mon, 19 Feb 2007 07:41:12 -0800, Ken wrote:

Excel 2003 ... I have a large Worksheet where some cell patterns are RED from
Conditional Formatting ... Some of these cells also include "invalid" data
(outside of Validation limits) ...

Above said ... When I circle the "invalid" data using the Audit Tool Bar ...
the "Validation Circles" are also RED & mostly obscured by the RED cell
patterns (Conditional Formating)

Bottom line ... I wish to change the color of the "Validation Circles" ...
Can this easily be done? ... If so ... How? ... Thanks ... Kha