Forum Discussion

bobdylan's avatar
bobdylan
Copper Contributor
Mar 11, 2024

How to automatic row row in a colour based on cell value

Hi All, 

 

I require some assistance on a problem. Please see below: 

 

Context:

Everyday a purchser supplies you with a new date for when a part will come into your fridge making factory. If the new date given changes from the one given from yesterdays, then this would like to be flagged.

 

The problem:

- When a date that is later than the date supplied yesterday is inputted into column B, how do you code a way so that the whole row fills in the colour red.

 

Thanks in Advance!

 

 

 

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor

    Hi bobdylan 

     

    With above setup:

    - Select A2:C5

    - Home (tab) > Conditional Formatting > New Rule... > Use a formula...:

    =$B2 > $C2

    - Select the desired formatting 

    • bobdylan's avatar
      bobdylan
      Copper Contributor

      Lorenzo 

       

      How do you get it so it just applies to the row you inputted the date in? 

      • Lorenzo's avatar
        Lorenzo
        Silver Contributor

        bobdylan 

        Your question makes no sense I'm afraid. What about a new/next rows where [Today] will be > [Yesterday]???

Resources