| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Invalid data circle disappers
I am just learning how to use Data Validation in an online college course I
am taking. My assignment is to set the Data Validation to warning and then deliberately enter invalid data to set off the warning. Then I am supposed to use the Formula Auditing toolbar to hightlight the invalid data and make the red circle appear. Everything works great until I try to protect or save the workbook, then the red circle around the invalid data disappears and the Formula Auditing toolbar is greyed out in the areas I need to use. Has anyone got an answer for this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set Circle Size from cell data? | Excel Discussion (Misc queries) | |||
| How do I make circle within circle graphs in Excel 2003? | Charts and Charting in Excel | |||
| How to print the circles in formatting audit circle invalid data | Excel Worksheet Functions | |||
| text disappers when sorting column | Excel Worksheet Functions | |||
| Data Validation: Printing Invalid Data Circles | Excel Discussion (Misc queries) | |||
Threaded Mode
