+ Reply to Thread
Results 1 to 5 of 5

vba to color certain cells

  1. 12-16-2018, 05:42 AM #1
    newtovba99
    newtovba99 is offline
    Registered User
    Join Date
    12-16-2018
    Location
    South Afric
    MS-Off Ver
    2013
    Posts
    12

    vba to color certain cells

    good day all
    i have a column with different letters
    i want a vba code to color the cells that contain the letter "c" red

    thanks
    Reply With QuoteRegister To Reply
  2. 12-16-2018, 06:02 AM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: vba to color certain cells

    Will it just be "c" the cell or are you looking for c in a string?
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 12-16-2018, 06:04 AM #3
    newtovba99
    newtovba99 is offline
    Registered User
    Join Date
    12-16-2018
    Location
    South Afric
    MS-Off Ver
    2013
    Posts
    12

    Re: vba to color certain cells

    the letter C in column a2 to a 1000
    Reply With QuoteRegister To Reply
  4. 12-16-2018, 06:13 AM #4
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: vba to color certain cells

    Here ya go,
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 12-16-2018, 06:20 AM #5
    newtovba99
    newtovba99 is offline
    Registered User
    Join Date
    12-16-2018
    Location
    South Afric
    MS-Off Ver
    2013
    Posts
    12

    Re: vba to color certain cells

    great
    thanks a million
    that works
    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. need macro to protect all cells which has no color and unprotect all cells wich has color
    By meonly123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-06-2015, 09:15 PM
  2. need macro to protect all cells which has no color and unprotect all cells wich has color
    By meonly123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2015, 09:10 PM
  3. Conditional Formatting - Color unprotected cells, remove color once text entered
    By jrc905 in forum Excel General
    Replies: 3
    Last Post: 05-30-2014, 10:24 AM
  4. Calculating cells based on the condition of color, but color is chosen via DROPDOWN choice
    By teanza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2014, 03:56 PM
  5. Find out if a range of cells match a criteria cell, if yes, color Green, if no color Red
    By r71lima in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 09-18-2012, 03:13 PM
  6. Automatically change fill color on certain cells depending on color of specific cell
    By cbouley in forum Excel General
    Replies: 3
    Last Post: 07-08-2010, 06:48 PM
  7. My excel 2003 wont let me fill cells with color or color the tabs.
    By trizog in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-23-2005, 01:58 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