+ Reply to Thread
Results 1 to 3 of 3

Dmax & dmin w/conditional formatting

  1. #1
    Registered User
    Join Date
    09-11-2009
    Location
    Bluffton, South Carolina
    MS-Off Ver
    Excel 2003
    Posts
    12

    Dmax & dmin w/conditional formatting

    I am stumped by what I thought would be a simple task. I want to highlight the highest and lowest of figures in a column using conditional formatting. There are 3 columns: A=Name, B=Perfect, C=Actual; wherein "Name" is one of 12 people, "Perfect" is their best possible performance and "Actual" is how they actually did. In CF, I entered a DMAX & DMIN formula I thought would highlight the top/bottom figure in each coulmn...not working! In column B-"Perfect", it looks like this:

    Condition 1
    Formula is=DMAX(A1:C13,B1,B2:B13)

    Condition 2
    Formula is=DMIN(...),

    and then repeat for column C-"Actual" =(...,C1, C2:C13).

    Either the cells ALL turn whatever color I enter as Condition 1 OR they aren't turning any color at all OR the top entry (B2, C2) ALWAYS turns Condition 1 regardless of rank, depending on minor changes in the formula.

    Someone please help!

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,615

    Re: Dmax & dmin w/conditional formatting

    can you upload dummy workbook?

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Dmax & dmin w/conditional formatting

    And what exactly are you looking to highlight ?

    The MAX Actual per individual (assuming they are repeated multiple times) or the MAX Actual across all persons ? Or MAX Perfect ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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