Conditional Formatting question
Conditional Formatting question
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Conditional Formatting question

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I'd like to conditionally format the last line of each sku (happens to be a total in this instance).....example of data

    SKU Sales
    101 1000
    101 2000
    101 2500
    101 5500
    102 1000
    102 2000
    102 3000
    103 500
    103 500
    104 1000
    104 1000
    104 5000
    104 7000

    want the last sku to be bold or red or something, and can't get formula correct.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Is the total always in the same cell?
    If so, no need for conditional formatting.

    Please give some more details???

    Tom

  3. #3
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Select the first cell in the SKU column that has data in it.

    Then select the Conditional Format from the Format bar item. In Condition 1, select "Formula is" in the formula box type this:

    =A3<>A2

    where A3 is the cell below your first cell and A2 is the data cell you are contitionally formatting.

    Then press "Format" select Bold font then select color (pick a color).

    hit OK

    Hit copy then block the other cells in the data range of "SKU" select "Paste special" select "Formats." That should do it. Hope this helps. JSW

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, I can get that far, but what I'd like is ........if the SKU changes, not just the last cell with the SKU to be bold, BUT THAT WHOLE ROW......that's where I'm having the difficulty....but thanks for the effort

  5. #5
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Use the same steps as above only select the whole row by clicking on the row lable. JSW

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,821
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-03-26 11:28, wi_guy wrote:
    I'd like to conditionally format the last line of each sku (happens to be a total in this instance).....example of data

    SKU Sales
    101 1000
    101 2000
    101 2500
    101 5500
    102 1000
    102 2000
    102 3000
    103 500
    103 500
    104 1000
    104 1000
    104 5000
    104 7000

    want the last sku to be bold or red or something, and can't get formula correct.
    Lets say that A1:B14 houses the sample you provided with labels in the first row.

    Select A2:A14.
    Activate Format|Conditional Formatting.
    Choose 'Formula Is' for 'Condition 1'.
    Enter, and this is important, in the formula box:

    =ROW(A2)=MATCH(A2,A:A)

    Activate Format.
    Select a color on the Patterns tab.
    Click OK, OK.

    & Enjoy.

    Aladin

    Addendum: If you want to color the whole row:

    Select rows 2 to 14.

    Use as formula:

    =ROW($A2)=MATCH($A2,$A:$A)



    [ This Message was edited by: Aladin Akyurek on 2002-03-26 12:57 ]

  7. #7
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Aladin's formula will work for you if you change it to:

    =ROW($A3)=MATCH($A2,$A:$A)

    he put a typo in =ROW($A2) should read =ROW($A3) as above. (I am sure it was a typo, Aladin is seldom off!) Block Conditional format all the row with the above formula and it will work. JSW

    My mistake Aladin's original formula was right (He's seldom wrong!) I did not understand how it worked?
    Tested it and found it worked fine, sorry. JSW


    [ This Message was edited by: Joe Was on 2002-03-26 13:36 ]

  8. #8
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,821
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-03-26 13:28, Joe Was wrote:
    Aladin's formula will work for you if you change it to:

    =ROW($A3)=MATCH($A2,$A:$A)

    he put a typo in =ROW($A2) should read =ROW($A3) as above. (I am sure it was a typo, Aladin is seldom off!) Block Conditional format all the row with the above formula and it will work. JSW
    Joe: It must be =ROW($A2), since the real data start at row 2, which I assumed. The data must also be sorted of course on SKU column.

  9. #9
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    My mistake Aladin's original formula was right (He's seldom wrong!) I did not understand how it worked?
    Tested it and found it worked fine, sorry. JSW

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com