creating additional cell patterns

H

Helen Bellato

Is there any way to create additional cell patterns in
excel? I want one with a single strikethrough line
horizontally through the middle and a totally white one
with a single transparent circle in the middle, so I can
apply the conditional formatting to change the colour of
the circle.

I have tried doing this with the draw function over the
top of the cells, but when I run a macro to hide blank
cells it ruins the alignment of the graphics, I need
something that is formatted in the cell.

Would be grateful for any ideas! Thanks.
 
Top