+ Reply to Thread
Results 1 to 2 of 2

Formula for adding certain amounts to various cells depending on text color in cell

  1. #1
    Registered User
    Join Date
    05-27-2013
    Location
    Myrtle Beach, South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    2

    Formula for adding certain amounts to various cells depending on text color in cell

    Hi,


    As part of an online simulation game I play, (Whatifsports - Hoops Dynasty) I am trying to incorporate using Excel into my recruiting for the game. I was hoping I could find a formula which will add certain amounts (20 for all blue text, 10 for all black text, and 3 for all red text) to all the cells in the worksheet.

    Since a 'season' lasts around 1 month, I do 'recruiting' quite often. Ideally I'm hoping to find a formula where I can have the formula input into the worksheet. Then once I transfer my color coded data into the sheet, it updates for me automatically. Doing so would save me a lot of time and hassle. Thanks for any help!

    Kyle

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Formula for adding certain amounts to various cells depending on text color in cell

    use autofilter by Color to filter
    http://www.dummies.com/how-to/conten...007-table.html

    when you have filtered you an easily assign any number you want against it

    the alternative requires VBA coding and formula adjustment using function similar to
    Please Login or Register  to view this content.
    for what you require i suggest the first one its much easier

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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