Hey all,
I've been out of the loop for while again and I've got a little (lot) rusty ...
I want to change the 'FILL Pattern' format of a cell to 25% gray when <> NUL, and to 'NO Fill Pattern' when = NUL or zero... [The 25% specs/dots fill pattern superimposed on top of the background fill color, but not the fill color itself]...
The basic code I understand, what I need quick help with is the proceedure or code(s) to change specifically the Fill Pattern (NOT the fill color, just the pattern) and then undo the fill pattern (Again, not erase all formatting, just remove the 25% fill pattern, leaving the background fill color intact ...)
Any ideas ?
THANKS AS ALWAYS !
Bookmarks