Change a cell's formatting, like 25% gray fill or L,R,T,B border color ???

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 !

Hello BaLLZaCH,

Here is macro to toggle the pattern and keep the cell's original color.

Please Login or Register  to view this content.

Ok cool that should work with some modding, but firstly I need to change the ''set cell = range("a1")" to the ''TARGET.ADDRESS' ....

It has ben so dang long I forgot how to use target.address , how would I use target.address to set the cell variable instead of using A1 as default ?


Thanks LEITH!

OHH DUHH to me, nevermind I can use target.interior .....

Thank you for your help Leith !!!

[Resolved]