Thread: How to print Circled Invalid Data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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?
Reply With QuoteReply With Quote