Conditional formatting

[Doublecork]

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 <strike></strike>

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[DanteAmor]

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.

 

[Doublecork]

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 <colgroup><col><col><col><col><col><col><col></colgroup><tbody> </tbody> <strike></strike>

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[DanteAmor]

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.

<tbody>
</tbody>

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:58.93px;" /><col style="width:59.88px;" /><col style="width:238.57px;" /><col style="width:26.61px;" /><col style="width:68.44px;" /><col style="width:124.51px;" /><col style="width:71.29px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >LINE0011</td><td style="text-align:right; ">86629917</td><td >2019 WMT DRS PAIN RELIEF PDQ 14PC</td><td style="text-align:right; ">9</td><td >NAZA597</td><td style="text-align:right; ">100000008237002.00</td><td style="text-align:right; ">28/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >LINE0011</td><td style="text-align:right; ">86629917</td><td >2019 WMT DRS PAIN RELIEF PDQ 14PC</td><td style="text-align:right; ">9</td><td >NAZA597</td><td style="text-align:right; ">100000008226539.00</td><td style="text-align:right; ">28/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >LINE0015</td><td style="text-align:right; ">86955849</td><td >2019 RITE AID CLARITIN SKNY TWR 32PC</td><td style="text-align:right; ">9</td><td >NAZA616</td><td style="text-align:right; ">100000008940510.00</td><td style="text-align:right; ">28/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >LINE0015</td><td style="text-align:right; ">86955849</td><td >2019 RITE AID CLARITIN SKNY TWR 32PC</td><td style="text-align:right; ">9</td><td >NAZA616</td><td style="text-align:right; ">100000008940509.00</td><td style="text-align:right; ">28/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >LINE0011</td><td style="text-align:right; ">86629917</td><td >2019 WMT DRS PAIN RELIEF PDQ 14PC</td><td style="text-align:right; ">9</td><td >NAZA597</td><td style="text-align:right; ">100000008226512.00</td><td style="text-align:right; ">28/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >LINE0009</td><td style="text-align:right; ">86593939</td><td >2019 WMT ALEVE LAG PDQ 22PC</td><td style="text-align:right; ">16</td><td >NAZA623</td><td style="text-align:right; ">100000008724748.00</td><td style="background-color:#ff0000; text-align:right; ">29/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >LINE0004</td><td style="text-align:right; ">86125323</td><td >CT SPORT SPRAY SPF50 5.5OZ 3PK</td><td style="text-align:right; ">91</td><td >CV019M0B</td><td style="text-align:right; ">100000008938969.00</td><td style="background-color:#ffff00; text-align:right; ">30/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >LINE0004</td><td style="text-align:right; ">86125323</td><td >CT SPORT SPRAY SPF50 5.5OZ 3PK</td><td style="text-align:right; ">125</td><td >CV019M4C</td><td style="text-align:right; ">100000008938963.00</td><td style="background-color:#ffff00; text-align:right; ">30/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >LINE0004</td><td style="text-align:right; ">86125323</td><td >CT SPORT SPRAY SPF50 5.5OZ 3PK</td><td style="text-align:right; ">125</td><td >CV019M4C</td><td style="text-align:right; ">100000008938968.00</td><td style="background-color:#ffff00; text-align:right; ">30/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >LINE0004</td><td style="text-align:right; ">86125323</td><td >CT SPORT SPRAY SPF50 5.5OZ 3PK</td><td style="text-align:right; ">125</td><td >CV019M4C</td><td style="text-align:right; ">100000008938967.00</td><td style="background-color:#ffff00; text-align:right; ">30/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td >LINE0004</td><td style="text-align:right; ">86125323</td><td >CT SPORT SPRAY SPF50 5.5OZ 3PK</td><td style="text-align:right; ">125</td><td >CV019M4C</td><td style="text-align:right; ">100000008938966.00</td><td style="background-color:#ffff00; text-align:right; ">30/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td >LINE0004</td><td style="text-align:right; ">86125323</td><td >CT SPORT SPRAY SPF50 5.5OZ 3PK</td><td style="text-align:right; ">125</td><td >CV019M4C</td><td style="text-align:right; ">100000008938965.00</td><td style="background-color:#ffff00; text-align:right; ">30/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td >LINE0004</td><td style="text-align:right; ">86125323</td><td >CT SPORT SPRAY SPF50 5.5OZ 3PK</td><td style="text-align:right; ">125</td><td >CV019M4C</td><td style="text-align:right; ">100000008938964.00</td><td style="background-color:#ffff00; text-align:right; ">30/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td >LINE0002</td><td style="text-align:right; ">86312328</td><td >Asp Cold Sparkling Original Taef 4s</td><td style="text-align:right; ">100</td><td >X23R34</td><td style="text-align:right; ">100000008226370.00</td><td style="background-color:#ffff00; text-align:right; ">30/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td >LINE0002</td><td style="text-align:right; ">86312328</td><td >Asp Cold Sparkling Original Taef 4s</td><td style="text-align:right; ">100</td><td >X23R34</td><td style="text-align:right; ">100000008938995.00</td><td style="text-align:right; ">31/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td >LINE0002</td><td style="text-align:right; ">86312328</td><td >Asp Cold Sparkling Original Taef 4s</td><td style="text-align:right; ">100</td><td >X23R34</td><td style="text-align:right; ">100000008938994.00</td><td style="text-align:right; ">31/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td >LINE0003</td><td style="text-align:right; ">85719505</td><td >CLAR 24HR TAB CLUB 10MG 105ct 1.5DZ</td><td style="text-align:right; ">50</td><td >NAA7EF8</td><td style="text-align:right; ">100000008931388.00</td><td style="text-align:right; ">31/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td >LINE0003</td><td style="text-align:right; ">85719505</td><td >CLAR 24HR TAB CLUB 10MG 105ct 1.5DZ</td><td style="text-align:right; ">49</td><td >NAA7EF8</td><td style="text-align:right; ">100000008931387.00</td><td style="text-align:right; ">31/05/2019</td></tr></table>

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

 

[Doublecork]

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

 

[DanteAmor]

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

 

[ClaireS]

Put a $ before the G in your conditional format formula.

 

[DanteAmor]

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