+ Reply to Thread
Results 1 to 2 of 2

Changing all colors in an excel file to black

  1. #1
    Forum Contributor
    Join Date
    02-18-2013
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2016
    Posts
    221

    Changing all colors in an excel file to black

    Hello,

    I am looking for a macro which does the following:

    I'm opening 20 excel files and the macro changes the color of any input in those files to black, so that everything is in one color only. Do you know how one can achieve this?

    Regards,

    excelactuary

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Changing all colors in an excel file to black

    perhaps
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ 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. Colors in Excel Sheets changing when I open a pivot table
    By mcgowan.b in forum Excel General
    Replies: 3
    Last Post: 05-14-2009, 04:12 AM
  2. Replies: 2
    Last Post: 02-24-2006, 12:10 PM
  3. Replies: 3
    Last Post: 04-11-2005, 05:39 PM
  4. [SOLVED] How do I change all chart colors to black and white?
    By deedee3 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-17-2005, 01:06 AM
  5. Changing #'s from Black to Red
    By David A in forum Excel General
    Replies: 3
    Last Post: 01-08-2005, 12:26 AM

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