+ Reply to Thread
Results 1 to 4 of 4

Colour fill

  1. #1
    Forum Contributor
    Join Date
    08-07-2013
    Location
    mo
    MS-Off Ver
    Excel 2010
    Posts
    453

    Colour fill

    I am wanting to colour fill all rows with no data white. (the whole sheet was white, but when I pasted a table there is no fill in between some charts. I want those row white also.)

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Colour fill

    Why not turn off the gridlines under the "View" ribbon?

  3. #3
    Forum Contributor
    Join Date
    08-07-2013
    Location
    mo
    MS-Off Ver
    Excel 2010
    Posts
    453

    Re: Colour fill

    Its in a macro and I am trying to not have to change settings each time im in excel. Can I fill black cells with colour fill white from A1:K:300 somehow?

  4. #4
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Colour fill

    I am not sure I totally follow you. You want to fill all blank cells with white color within A1:K300?

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 09-12-2013, 02:09 PM
  2. Command Buttons for Fill Colour and Font Colour
    By Gos-C in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-14-2011, 07:11 AM
  3. changing all text boxes of one fill colour to another colour
    By was0696 in forum Word Formatting & General
    Replies: 3
    Last Post: 02-18-2010, 05:57 AM
  4. Conditional Formatting Fill colour with weekday colour
    By nattasiray in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2008, 06:49 AM
  5. Replies: 1
    Last Post: 06-10-2005, 11:05 PM

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