Results 1 to 6 of 6

Excel 2010 - Icon Set (3 conditions) Based on Cell Value Across

Threaded View

  1. #1
    Registered User
    Join Date
    08-01-2011
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    3

    Unhappy Excel 2010 - Icon Set (3 conditions) Based on Cell Value Across


    Hi,

    I have uploaded a sample Excel 2010 file with example problem I am having trying to implement Icon Sets.
    The spreadsheet contains an “Estimate” Column (B) which is supposed to show a red, yellow, or green icon based the cell value across from it in the “Labor Hours Total” Column (A).

    I believe the setup conditional formula should show the prefer icon based on how it’s setup which is:

    1. Red: “Estimate” Hours is greater than the “Labor Hours Total”
    2. Green: “Estimate” Hours is greater than 0 or Equal to “Labor Hours Total”
    3. Yellow: “Estimate” Hours is 0 or less than “Labor Hours Total”

    However, it appears that the only value being referenced in the conditional format is cell A2 which is referred to as $A$2 in the conditional format.
    Can anyone help suggest what I need to do above? I need the Estimate value which is a calculated field to show at all times since it is consistently being referred to so I can replace it with a 1,-1, 0 value.

    I am really hoping someone help and I’m sorry if this seems like a repost. I just couldn't seem to find a similar problem in the forums.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Modify Excel 2010 Quick Access Toolbar Macro Icon using VBA
    By unhappyCamper in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2014, 11:46 AM
  2. EMBEDDING / ATTACHING OBJECTS INTO EXCEL 2010 - Missing OLE Object icon???
    By EatBiscuits in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2013, 11:36 AM
  3. Conditional icon formatting in pivot excel 2010 to stay with refresh
    By newbieexcelgirl in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-19-2012, 04:22 PM
  4. Replies: 8
    Last Post: 11-09-2012, 07:28 AM
  5. Delete Conditional Formatting conditions but keep cell formatting - Excel 2010
    By tetreama in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2012, 08:28 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