+ Reply to Thread
Results 1 to 5 of 5

Cell increment based on fill colour

  1. #1
    Registered User
    Join Date
    01-16-2017
    Location
    UK
    MS-Off Ver
    2010
    Posts
    3

    Cell increment based on fill colour

    Please Login or Register  to view this content.
    Hi Guys,

    Can anyone help with a problem I have. I need to increase a cell count by 1 or 0.5 based on the fill colour of the cell. I am using the following code to increment the count by 1, which works fine, but i also need to increment the cell count by 0.5 if the cell is a different colour. I am using Excel 2010. Any help would be much appreciated.

    Please Login or Register  to view this content.
    Many Thanks
    Last edited by SecretS; 01-16-2017 at 07:29 AM. Reason: missing code tags

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Cell increment based on fill colour

    Hi and welcome to the forum. Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I'll change it for you on this occasion but note for the future.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Cell increment based on fill colour

    ...put an Else clause in the IF block

  4. #4
    Registered User
    Join Date
    01-16-2017
    Location
    UK
    MS-Off Ver
    2010
    Posts
    3

    Re: Cell increment based on fill colour

    Thank you Richard


  5. #5
    Registered User
    Join Date
    01-16-2017
    Location
    UK
    MS-Off Ver
    2010
    Posts
    3

    Re: Cell increment based on fill colour

    Hi Richard,
    I am an excel novice so could you expand on your comment regarding the "Else clause" please.

    Many Thanks

+ 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. Fill Colour Based on another cell's value
    By sshblack88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-05-2016, 04:46 PM
  2. Fill cell colour based on another cells contents.
    By Jamesbil in forum Excel General
    Replies: 14
    Last Post: 04-25-2016, 03:41 PM
  3. Fill cell with colour based on a ranged value?
    By DannyWinning in forum Excel General
    Replies: 1
    Last Post: 01-14-2014, 10:53 AM
  4. Change fill colour based on text in a cell
    By Doogles10 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 07-01-2013, 03:30 PM
  5. Fill Colour of a cell based on another cell Fill Colour
    By ConorK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2012, 07:09 AM
  6. Fill cell colour based on value
    By bd528 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-16-2010, 08:47 AM
  7. Changing cell fill colour based on date in cell - Multiple rows
    By ExcelNewb2010 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2010, 07:30 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