Results 1 to 8 of 8

Thread: Conditional Format If this happens!
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Dec 2013
    Posts
    108
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional Format If this happens!

    Let's say I have 3 columns with 3 numbers in them.

    Example ... Columns R-S-T ... In these cells are the following numbers.

    9-12-19

    Now what I want to do is highlight the whole row of all 3 numbers IF: the very first number (9)
    is lower than both of the other two. (12-19)

    I can get it to work if I Conditionally Format a single row at a time.
    I can't get it to copy (paint brush) the format down the Column of the sheet.
    It just copies the very first cell format down the sheet.

    Here is my current formula: =$Q12<$R12:S$12

    Any formula that you have to help me out is very much Appreciated!

    Thanks in advance!!
    U.S.

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,177
    Post Thanks / Like
    Mentioned
    470 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Conditional Format If this happens!

    Select the rows you want it to work on & use
    =$Q12< MIN($R12:S$12)
    Where row12 is the first row in the applies range
    Last edited by Fluff; Jul 6th, 2019 at 03:16 PM.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    Board Regular Aryatect's Avatar
    Join Date
    Jun 2019
    Location
    Chicago, USA
    Posts
    308
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Conditional Format If this happens!

    Hi,

    This should work, I have applied the formula in Column R selecting all 3 R-S-T Columns:

    https://drive.google.com/open?id=1Kh..._HsPduxGtpudVY

    https://drive.google.com/open?id=1N3...7ngiFycSJRMLDt

    https://drive.google.com/open?id=1iC...VmRafdEIVnIWdM

    your formula should work as @Fluff has given above. Alternate formula would be:
    =AND($R1<$S1,$R1<$T1)
    Last edited by Aryatect; Jul 6th, 2019 at 02:37 PM. Reason: adding alternate
    Thanks!

    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes

  4. #4
    Board Regular
    Join Date
    Dec 2013
    Posts
    108
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Format If this happens!

    Quote Originally Posted by Aryatect View Post
    Hi,

    This should work, I have applied the formula in Column R selecting all 3 R-S-T Columns:

    https://drive.google.com/open?id=1Kh..._HsPduxGtpudVY

    https://drive.google.com/open?id=1N3...7ngiFycSJRMLDt

    https://drive.google.com/open?id=1iC...VmRafdEIVnIWdM

    your formula should work as @Fluff has given above. Alternate formula would be:
    =AND($R1<$S1,$R1<$T1)
    Thanks Aryatect! great examples pics! works fantastic ... however, the only issue is that it will highlight just a single cell of the three cells. I need it to highlight all three cells ONLY if the first cell is LOWER that the other two cells.

    Any ideas? Thanks!

  5. #5
    Board Regular
    Join Date
    Dec 2013
    Posts
    108
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Format If this happens!

    The conditional format formula will also NOT copy down the row. It keeps just that first cells formula all the way down!

  6. #6
    Board Regular Aryatect's Avatar
    Join Date
    Jun 2019
    Location
    Chicago, USA
    Posts
    308
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Conditional Format If this happens!

    Hi, as @Fluff wrote in #2 you’ll need to select all three rows so that conditional formatting works for all the 3 rows

  7. #7
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,177
    Post Thanks / Like
    Mentioned
    470 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Conditional Format If this happens!

    With the formula from post#2 I get

    Excel 2016 (Windows) 32 bit
    QRS
    1291219
    139819
    1491219
    159122
    1691219
    17151219
    1862015
    197511
    201019
    2191219

    VBAinputs




    Where the applies to range is Q12:S21
    Last edited by Fluff; Jul 6th, 2019 at 03:35 PM.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  8. #8
    Board Regular
    Join Date
    Dec 2013
    Posts
    108
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Format If this happens!

    I got it figured out guys! Here is the other step that needs to be included in the formula.

    =AND($Q6<$R6,$Q6<$S6,$R6<$S6)

    It seems you can't formula copy all the rows at one time.
    I did however copy row by row individually and that did work!

    Thanks for all the input fellas! Much Appreciated and have a great weekend!

    Regards,
    U.S.

Some videos you may like

User Tag List

Tags for this Thread

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
  •