+ Reply to Thread
Results 1 to 3 of 3

if statment to find if Font.ColorIndex = 3

  1. 09-30-2013, 09:06 AM #1
    cdafonseca
    cdafonseca is offline
    Registered User
    Join Date
    02-27-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    38

    if statment to find if Font.ColorIndex = 3

    i need a statement to find


    with a range (c5:c160) if the Font.ColorIndex = 3 then msgbox()
    Reply With QuoteRegister To Reply
  2. 09-30-2013, 09:47 AM #2
    djdjdj
    djdjdj is offline
    Forum Contributor
    Join Date
    04-25-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    150

    Re: if statment to find if Font.ColorIndex = 3

    hi,

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 09-30-2013, 12:03 PM #3
    cdafonseca
    cdafonseca is offline
    Registered User
    Join Date
    02-27-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    38

    Re: if statment to find if Font.ColorIndex = 3

    this sub did not work for me

    nothing wrong it was my mistake
    Last edited by cdafonseca; 09-30-2013 at 02:41 PM.
    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. Changing font.colorindex on non active sheet
    By coasterman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2012, 06:49 PM
  2. Unable to set ColorIndex font property?
    By FuzzyDove in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2009, 12:38 PM
  3. Can't set font.colorindex from VBA
    By Mike Jamesson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-19-2005, 10:05 AM
  4. [SOLVED] VBA Error setting Font.ColorIndex
    By Steve Barnett in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-24-2005, 06:05 AM
  5. If Font.ColorIndex = 5 then . . .
    By jeremy nickels in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2005, 08:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1