Color of Validation Circles?

K

Ken

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation: Printing Invalid Data Circles 1
Invalid Circles - Can I force their display? 5
change the color of yellow tip box on data validation 1
color coding 2
Changing the color of a cell based on the color of another cell. 7
Data Validation/Conditional Formating 3
Using named formula in validation 8
VB Data Validation check 1

Top