| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in a data validation list how do i color a choice? | Excel Discussion (Misc queries) | |||
| Color cell validation? | Excel Discussion (Misc queries) | |||
| Data Validation: Printing Invalid Data Circles | Excel Discussion (Misc queries) | |||
| Circles | Excel Discussion (Misc queries) | |||
| Data Validation circles | Excel Worksheet Functions | |||
Linear Mode
