+ Reply to Thread
Results 1 to 2 of 2

Modifying formula based on cell color

  1. #1
    Registered User
    Join Date
    01-26-2015
    Location
    USA
    MS-Off Ver
    Microsoft Office 2010
    Posts
    24

    Modifying formula based on cell color

    Good evening,

    I need help figuring out how to modify a formula in one cell based on the color of another cell if that makes sense? I'll explain. I have a spreadsheet with 6 digit numbers from B2:B50.. I then take another list of about 15 6 digit numbers and place it under B50.. These are all duplicates of the top numbers.. I use the conditional formatting to highlight all item #s that are duplicate in column B with the default light red background and dark red letters.. In columns D:G starting in row 2 I have single digit item #s that correspond to the item numbers in column B and in column I have formulas going from I2:I50.. the default formula is a simple =SUM(D2,F2) what I want to do is based on the color of the cells in column B (the duplicates) change the formula to =SUM(E2,G2) since I will technically be dragging down the formula and not wanting to edit each one by hand.. Is this possible? If it is too confusing I can upload a sample spreadsheet.. but don't know how? Thank you in advance!!

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

    Re: Modifying formula based on cell color

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Set Cell Color based on a formula
    By alewson in forum Excel General
    Replies: 5
    Last Post: 08-18-2015, 05:24 PM
  2. Color tab based on cell value but ignore formula
    By freeon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-12-2013, 03:41 PM
  3. Modifying an auto-shape with VBA (based on cell value)
    By Cboggie in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-23-2013, 01:15 PM
  4. Modifying 'LIST' function based on value in anotehr cell
    By Bptacek in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2013, 04:42 PM
  5. Display one cell value based on modifying another
    By Kyle Bennett in forum Excel General
    Replies: 0
    Last Post: 08-31-2011, 11:25 AM
  6. formula to set font color based on value in other cell
    By happycats in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-03-2009, 01:08 PM
  7. formula based on cell background color
    By seyah in forum Excel General
    Replies: 2
    Last Post: 05-11-2007, 05:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1