+ Reply to Thread
Results 1 to 1 of 1

Format cell value based on color(style) of another cell

  1. #1
    Registered User
    Join Date
    London, England
    MS-Off Ver
    Excel 2010

    Format cell value based on color(style) of another cell

    Hello everyone,

    I trying to create a sheet for tracking weightlifting progress. What I would like to happen is update a cell value based on the color (style) of another cell.

    So in context; if the weight specified has been lifted successfully the [Good] style is manually applied by the user, if a lift has been unsuccessful the [Bad] style is applied manually by the user.

    The on the next sheet the values are updated accordingly. If the cell has been colored [Good] the value in the cell is increased by 10%, if colored [Bad] the same stays the same as previously.

    I know that this formula is completely wrong, but as an idea of what I would like to achieve: =SUMIF('Cycle 1'!C3 is [Good]*1.1) ELSE('Cycle 1!C3) or something like that.

    Looking around the forum, there is lots to change cell colors based on values, but not the other way around. Is this an easy formula or will some VB scripting be needed. Any assistance will be gratefully received.

    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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