+ Reply to Thread
Results 1 to 1 of 1

Conditional formatting Problem! [Excel 2011 MAC]

  1. #1
    Registered User
    Join Date
    07-25-2013
    Location
    Portugal
    MS-Off Ver
    Excel 2011
    Posts
    1

    Conditional formatting Problem! [Excel 2011 MAC]

    So what I'm trying to do Is creating a new cell result in which i calculte a value. This value is the difference between the values of Cell G2 - (The sum of the values which names are turned green)
    How do i do to automatically get all the values that have green names?

    Or just creating a function using VLOOKUP or something that subtracts G2 with all the prices that have equal amount and available times its amount.
    Attached Images Attached Images
    Last edited by Prohybe; 07-25-2013 at 10:15 AM.

+ 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. [SOLVED] Question in conditional formatting Excel Mac 2011
    By so_fistica_ted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 07-06-2013, 05:29 AM
  2. Can't figure out a formula for Conditional Formatting- Excel 2011
    By so_fistica_ted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 11-30-2012, 10:20 AM
  3. Replies: 5
    Last Post: 02-28-2012, 04:47 PM
  4. Replies: 1
    Last Post: 08-10-2011, 12:45 AM
  5. Excel 2011 Conditional Formating Icon Help
    By TravelersLandscaping in forum Excel General
    Replies: 5
    Last Post: 05-16-2011, 08:12 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