+ Reply to Thread
Results 1 to 3 of 3

Red Cell but nbeed White font in loop

  1. 10-22-2015, 04:15 PM #1
    swade730
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Red Cell but nbeed White font in loop

    Hi,

    How can I alter this line of code to not only change the cell to red but have white letter font

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 10-22-2015, 04:26 PM #2
    Cheetahke
    Cheetahke is offline
    Registered User
    Join Date
    10-10-2015
    Location
    Hoboken, Antwerp, Belgium
    MS-Off Ver
    2010
    Posts
    93

    Re: Red Cell but nbeed White font in loop

    Hi

    This is to set the font color to white:
    Please Login or Register  to view this content.
    Or:
    Please Login or Register  to view this content.
    You can also use colorindex, but I don't know by heart what the colorindex for white is.
    Greetings,

    Cheetahke
    Reply With QuoteRegister To Reply
  3. 10-23-2015, 09:28 AM #3
    swade730
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Red Cell but nbeed White font in loop

    Thank You. - Marking thread as solved
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro changing font color to white instead of gray
    By bwmuhich in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-20-2015, 10:40 PM
  2. [SOLVED] VB code to change the font to white for selected range
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-23-2014, 11:54 AM
  3. Macro to add data labels and color font white in Active Tab for all charts?
    By Dude to Excel Dude in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2014, 01:54 PM
  4. Entering Code for [If cell (a1) is white, cell (a2:a3) is yellow and cell (a4) is white]
    By tedong in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-07-2012, 02:34 AM
  5. [SOLVED] For all cells with font size bigger than 9, make that cell bold and color white
    By jasondu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2012, 02:18 PM
  6. [SOLVED] white font in certain cells
    By Jon in forum Excel General
    Replies: 5
    Last Post: 11-04-2005, 07:35 PM
  7. [SOLVED] macro to white out (to change a font in selected cells)
    By Abi in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-03-2005, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1