Results 1 to 8 of 8

Thread: Conditional formatting
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2009
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional formatting

    I am trying to figure out how to get all the cells to highlight when I use conditional formatting. I am able to get one Colom to highlight but not any of the cells next to it. This is what I used to get what I have in colom G
    =TODAY()-2 =TODAY()-3 to turn them yellow

    =TODAY()-3 =TODAY()-4 to turn them red

    How do I get A to F to turn the same color as G


  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,188
    Post Thanks / Like
    Mentioned
    67 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Conditional formatting

    What is the condition?

    =TODAY()-2 =TODAY()-3

    =TODAY()-2 = May / 30
    =TODAY()-3 = May / 29

    May / 30 it is not equal to May / 29

    Then the result is false

    Then it will not highlight anything.
    The condition format highlight when the condition is true.
    Regards Dante Amor

  3. #3
    New Member
    Join Date
    Sep 2009
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting

    I run a report to find items that have not been move from a production line. If it is more than two day it need to show in yellow and red if more than three days.



    LINE0011 86629917 2019 WMT DRS PAIN RELIEF PDQ 14PC 9 NAZA597 100000008237002 5/28/2019 15:19
    LINE0011 86629917 2019 WMT DRS PAIN RELIEF PDQ 14PC 9 NAZA597 100000008226539 5/28/2019 18:02
    LINE0015 86955849 2019 RITE AID CLARITIN SKNY TWR 32PC 9 NAZA616 100000008940510 5/28/2019 18:11
    LINE0015 86955849 2019 RITE AID CLARITIN SKNY TWR 32PC 9 NAZA616 100000008940509 5/28/2019 18:17
    LINE0011 86629917 2019 WMT DRS PAIN RELIEF PDQ 14PC 9 NAZA597 100000008226512 5/28/2019 21:09
    LINE0009 86593939 2019 WMT ALEVE LAG PDQ 22PC 16 NAZA623 100000008724748 5/29/2019 21:13
    LINE0004 86125323 CT SPORT SPRAY SPF50 5.5OZ 3PK 91 CV019M0B 100000008938969 5/30/2019 7:23
    LINE0004 86125323 CT SPORT SPRAY SPF50 5.5OZ 3PK 125 CV019M4C 100000008938963 5/30/2019 8:36
    LINE0004 86125323 CT SPORT SPRAY SPF50 5.5OZ 3PK 125 CV019M4C 100000008938968 5/30/2019 8:36
    LINE0004 86125323 CT SPORT SPRAY SPF50 5.5OZ 3PK 125 CV019M4C 100000008938967 5/30/2019 9:25
    LINE0004 86125323 CT SPORT SPRAY SPF50 5.5OZ 3PK 125 CV019M4C 100000008938966 5/30/2019 10:47
    LINE0004 86125323 CT SPORT SPRAY SPF50 5.5OZ 3PK 125 CV019M4C 100000008938965 5/30/2019 11:33
    LINE0004 86125323 CT SPORT SPRAY SPF50 5.5OZ 3PK 125 CV019M4C 100000008938964 5/30/2019 12:24
    LINE0002 86312328 Asp Cold Sparkling Original Taef 4s 100 X23R34 100000008226370 5/30/2019 17:37
    LINE0002 86312328 Asp Cold Sparkling Original Taef 4s 100 X23R34 100000008938995 5/31/2019 7:37
    LINE0002 86312328 Asp Cold Sparkling Original Taef 4s 100 X23R34 100000008938994 5/31/2019 9:59
    LINE0003 85719505 CLAR 24HR TAB CLUB 10MG 105ct 1.5DZ 50 NAA7EF8 100000008931388 5/31/2019 10:02
    LINE0003 85719505 CLAR 24HR TAB CLUB 10MG 105ct 1.5DZ 49 NAA7EF8 100000008931387 5/31/2019 11:19

  4. #4
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,188
    Post Thanks / Like
    Mentioned
    67 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Conditional formatting

    Quote Originally Posted by Doublecork View Post
    I run a report to find items that have not been move from a production line. If it is more than two day it need to show in yellow and red if more than three days.

     ABCDEFG
    1       
    2LINE0011866299172019 WMT DRS PAIN RELIEF PDQ 14PC9NAZA597100000008237002.0028/05/2019
    3LINE0011866299172019 WMT DRS PAIN RELIEF PDQ 14PC9NAZA597100000008226539.0028/05/2019
    4LINE0015869558492019 RITE AID CLARITIN SKNY TWR 32PC9NAZA616100000008940510.0028/05/2019
    5LINE0015869558492019 RITE AID CLARITIN SKNY TWR 32PC9NAZA616100000008940509.0028/05/2019
    6LINE0011866299172019 WMT DRS PAIN RELIEF PDQ 14PC9NAZA597100000008226512.0028/05/2019
    7LINE0009865939392019 WMT ALEVE LAG PDQ 22PC16NAZA623100000008724748.0029/05/2019
    8LINE000486125323CT SPORT SPRAY SPF50 5.5OZ 3PK91CV019M0B100000008938969.0030/05/2019
    9LINE000486125323CT SPORT SPRAY SPF50 5.5OZ 3PK125CV019M4C100000008938963.0030/05/2019
    10LINE000486125323CT SPORT SPRAY SPF50 5.5OZ 3PK125CV019M4C100000008938968.0030/05/2019
    11LINE000486125323CT SPORT SPRAY SPF50 5.5OZ 3PK125CV019M4C100000008938967.0030/05/2019
    12LINE000486125323CT SPORT SPRAY SPF50 5.5OZ 3PK125CV019M4C100000008938966.0030/05/2019
    13LINE000486125323CT SPORT SPRAY SPF50 5.5OZ 3PK125CV019M4C100000008938965.0030/05/2019
    14LINE000486125323CT SPORT SPRAY SPF50 5.5OZ 3PK125CV019M4C100000008938964.0030/05/2019
    15LINE000286312328Asp Cold Sparkling Original Taef 4s100X23R34100000008226370.0030/05/2019
    16LINE000286312328Asp Cold Sparkling Original Taef 4s100X23R34100000008938995.0031/05/2019
    17LINE000286312328Asp Cold Sparkling Original Taef 4s100X23R34100000008938994.0031/05/2019
    18LINE000385719505CLAR 24HR TAB CLUB 10MG 105ct 1.5DZ50NAA7EF8100000008931388.0031/05/2019
    19LINE000385719505CLAR 24HR TAB CLUB 10MG 105ct 1.5DZ49NAA7EF8100000008931387.0031/05/2019


    Formulas on Conditional Formatting:
    Red color
    =G2=(TODAY()-3)
    Applies To:
    =$G$2:$G$19

    Yellow Color
    =G2=(TODAY()-2)
    Applies To:
    =$G$2:$G$19
    Regards Dante Amor

  5. #5
    New Member
    Join Date
    Sep 2009
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting

    My question is how do I get A through F to highlight the same color as G?

  6. #6
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,188
    Post Thanks / Like
    Mentioned
    67 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Conditional formatting

    Quote Originally Posted by Doublecork View Post
    My question is how do I get A through F to highlight the same color as G?
    You're right.
    In applies to:
    =$A$2:$F$19

    ​Change 19 to the row number of the last row with data
    Regards Dante Amor

  7. #7
    Board Regular
    Join Date
    Jul 2013
    Location
    Essex, UK
    Posts
    128
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting

    Put a $ before the G in your conditional format formula.
    Last edited by ClaireS; Jun 2nd, 2019 at 02:15 PM.

    Helping you to Excel

  8. #8
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,188
    Post Thanks / Like
    Mentioned
    67 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Conditional formatting

    Quote Originally Posted by ClaireS View Post
    Put a $ before the G in your conditional format formula.
    Thanks Claire.

    It must be like Claire says.

    It would be like this:

    Formulas on Conditional Formatting:
    Red color
    =$G2=(TODAY()-3)
    Applies To:
    =$A$2:$F$19

    Yellow Color
    =$G2=(TODAY()-2)
    Applies To:
    =$A$2:$F$19
    Regards Dante Amor

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
  •