+ Reply to Thread
Results 1 to 19 of 19

Conditional Formating

  1. #1
    Registered User
    Join Date
    04-25-2020
    Location
    Milan
    MS-Off Ver
    Office365
    Posts
    10

    Post Conditional Formating

    How can I find the max Carrello in RM by using Conditional formatting on the store_id column?

    So the right one should be :
    1 5529 Store E RM UNAIUTOX65 291

    with 5529 highlighted



    orders store_id store_partner operating_province discount_code Carrello
    1 1839 Store A UD UNAIUTOX65 126
    1 2833 Store A-franchising RM UNAIUTOX65 52
    1 5207 Store B TO UNAIUTOX65 107
    1 5412 Store A-franchising SV UNAIUTOX65 153
    1 5797 Store C RM UNAIUTOX65 156
    1 5541 Store D MI UNAIUTOX65 206
    1 2801 Store A RM UNAIUTOX65 275
    1 5529 Store E RM UNAIUTOX65 291
    1 2844 Store G RM UNAIUTOX65 133
    1 2163 Store A BS UNAIUTOX65 59
    1 5850 Store D RO UNAIUTOX65 230
    1 157 Store G BS UNAIUTOX65 291
    1 2931 Store G RM UNAIUTOX65 227
    1 5854 Store F PV UNAIUTOX65 130
    1 5407 Store G TO UNAIUTOX65 95
    1 5468 Store F PD UNAIUTOX65 138
    1 5058 Store D TV UNAIUTOX65 240
    1 3352 Store G PR UNAIUTOX65 283
    1 2070 Store A BG UNAIUTOX65 123
    Last edited by simeonovalily; 04-25-2020 at 06:06 PM.

  2. #2
    Registered User
    Join Date
    04-25-2020
    Location
    Milan
    MS-Off Ver
    Office365
    Posts
    10

    Re: Conditional Formating

    Please let me know if you need clarification

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,682

    Re: Conditional Formating

    A orders
    B store_id
    C store_partner
    D operating_province
    E discount_code
    F Carrello

    setup a formula for conditional formatting
    Select column B
    now as the formula

    =$F1 = MAX($F:$F)

    But 2 rows have 291

    1 5529 Store E RM UNAIUTOX65 291
    1 157 Store G BS UNAIUTOX65 291
    Attached Files Attached Files
    Last edited by etaf; 04-25-2020 at 06:49 PM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Registered User
    Join Date
    04-25-2020
    Location
    Milan
    MS-Off Ver
    Office365
    Posts
    10

    Re: Conditional Formating

    Yes, however, I must use conditional formating to highlight only the one for RM.

    I am looking for the max of Carrello, with respect to RM.
    Last edited by simeonovalily; 04-25-2020 at 06:53 PM.

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,682

    Re: Conditional Formating

    "RM"
    is that in a separate Column?
    NOT clear form post
    perhaps a sample sheet uploaded here would help further
    See my sheet used spaces to split the columns but need to know the exact layout

  6. #6
    Registered User
    Join Date
    04-25-2020
    Location
    Milan
    MS-Off Ver
    Office365
    Posts
    10

    Re: Conditional Formating

    I will upload it right now

  7. #7
    Registered User
    Join Date
    04-25-2020
    Location
    Milan
    MS-Off Ver
    Office365
    Posts
    10

    Re: Conditional Formating

    Attachment 674465

    Here it is

  8. #8
    Registered User
    Join Date
    04-25-2020
    Location
    Milan
    MS-Off Ver
    Office365
    Posts
    10

    Re: Conditional Formating

    My question is:

    What’s the store_id with the highest Carrello in RM?

  9. #9
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,682

    Re: Conditional Formating

    =and($f1=maxifs(f:f,e:e,"rm"&"*"),left(e1,2)="rm")

  10. #10
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,682

    Re: Conditional Formating

    see yellow banner for attachment
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    04-25-2020
    Location
    Milan
    MS-Off Ver
    Office365
    Posts
    10

    Re: Conditional Formating

    I'm so sorry but the conditional formatting does not seem to work

  12. #12
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,682

    Re: Conditional Formating

    you have office 365 = maxifs function

  13. #13
    Registered User
    Join Date
    04-25-2020
    Location
    Milan
    MS-Off Ver
    Office365
    Posts
    10

    Re: Conditional Formating

    The columns Operating Province is this:

    operating_province
    UD
    RM
    TO
    SV
    RM
    MI
    RM
    RM
    RM
    BS
    RO
    BS
    RM
    PV
    TO
    PD
    TV
    PR
    BG

  14. #14
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,682

    Re: Conditional Formating

    OK so not the same as the sheet i loaded then
    Column D ?

  15. #15
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,682

    Re: Conditional Formating

    =and($f1=maxifs(f:f,D:D,"rm"),D1="rm")

  16. #16
    Registered User
    Join Date
    04-25-2020
    Location
    Milan
    MS-Off Ver
    Office365
    Posts
    10

    Re: Conditional Formating

    Attachment 674468

    Here is what the table looks like

  17. #17
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,682

    Re: Conditional Formating

    attachment still not working
    see yellow banner of how to upload a sheet here

    HOW TO ATTACH YOUR SAMPLE WORKBOOK:
    etaf Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

  18. #18
    Registered User
    Join Date
    04-25-2020
    Location
    Milan
    MS-Off Ver
    Office365
    Posts
    10

    Re: Conditional Formating

    Oh my goodness!! It worked! Thank you so much!

  19. #19
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,682

    Re: Conditional Formating

    you are welcome
    Attached Files Attached Files

+ 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. Conditional formating based on other conditional formating?
    By OldManExcellor in forum Excel General
    Replies: 11
    Last Post: 09-14-2014, 02:20 PM
  2. Replies: 5
    Last Post: 03-14-2014, 04:03 AM
  3. Replies: 4
    Last Post: 01-23-2014, 10:14 AM
  4. Replies: 6
    Last Post: 08-14-2006, 05:00 PM
  5. Replies: 2
    Last Post: 03-27-2006, 12:10 PM
  6. Install dates formating using conditional formating?
    By Jerry Eggleston in forum Excel General
    Replies: 2
    Last Post: 11-09-2005, 01:49 PM
  7. Replies: 1
    Last Post: 03-08-2005, 03:06 PM

Tags for this Thread

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