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

[bobdylan]

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!

[#2]

Hi @bobdylan 

With above setup:

- Select A2:C5

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

=$B2 > $C2

- Select the desired formatting 

[#3]

@L z. 

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

[#4]

@bobdylan 

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