+ Reply to Thread
Results 1 to 6 of 6

chage cell color to "white" if it isnt "grey"

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    19

    chage cell color to "white" if it isnt "grey"

    I need to create code that evalates a cell's color in a column range "u4:u240" and if doesnt match a certain color(grey) then change cell color back to white. i dont want to use coditional formatting either.

    thanks,

    cb

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: chage cell color to "white" if it isnt "grey"

    Please Login or Register  to view this content.
    Lookup "ColorIndex" in Help
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    06-12-2013
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: chage cell color to "white" if it isnt "grey"

    I am getting an error of "for without next"


    Sent from my iPad using Tapatalk

  4. #4
    Registered User
    Join Date
    06-12-2013
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: chage cell color to "white" if it isnt "grey"

    I got it, it was missing "next c". Thanks!


    Sent from my iPad using Tapatalk

  5. #5
    Registered User
    Join Date
    06-12-2013
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: chage cell color to "white" if it isnt "grey"

    Can you have it ignore black and grey? Not equal this color and this color?


    Sent from my iPad using Tapatalk

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: chage cell color to "white" if it isnt "grey"

    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. [SOLVED] Cell Color with"if" statement testing for a "text" value
    By ARocketScientist in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-08-2014, 09:01 PM
  2. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  3. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  4. Replies: 1
    Last Post: 07-11-2012, 01:54 AM
  5. cell to change color =IF(B7>53,"Critical","Normal")
    By fgiord in forum Excel General
    Replies: 3
    Last Post: 08-18-2005, 05:05 PM

Tags for this Thread

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