ExcelBanter - How to print Circled Invalid Data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to print Circled Invalid Data (https://www.excelbanter.com/excel-discussion-misc-queries/175716-how-print-circled-invalid-data.html)

Alison

How to print Circled Invalid Data

Is there a way to print the red circles indicating invalid data entries?

Gary''s Student

How to print Circled Invalid Data

Insert an AutoShape circle on top of the invalid number. You can then:

1. set Transparency to see the number
2. make the circle red
3. make the interior of the circle red

these are done by right-clicking the AutoShape and picking Format AutoShape...

--
Gary''s Student - gsnu200767

"Alison" wrote:

Is there a way to print the red circles indicating invalid data entries?

All times are GMT +1. The time now is 02:22 AM.