+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    02-08-2004
    Posts
    58

    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 !
    Last edited by BaLLZaCH; 06-27-2009 at 06:55 PM.
    Sig ? How can I sign the computer screen ?

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,255

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

    Hello BaLLZaCH,

    Here is macro to toggle the pattern and keep the cell's original color.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    02-08-2004
    Posts
    58

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


    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]
    Last edited by BaLLZaCH; 06-27-2009 at 05:36 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1