Fill Cell Based on Date

[slparadise]

I have a spreadsheet with various inspection dates. I would like the fill of each cell to change based on the current date versus the expected date of the inspection.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Inspection[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]Plumbing[/TD]
[TD]4/14/2019[/TD]
[/TR]
[TR]
[TD]Electric[/TD]
[TD]4/16/2019[/TD]
[/TR]
[TR]
[TD]Decking[/TD]
[TD]4/18/2019[/TD]
[/TR]
[TR]
[TD]Final[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What I would like is for dates that have passed (Plumbing) to have a red fill, dates that are equal to the current date to have a blue fill, dates that have not yet occurred to have a yellow fill, and blank cells to have no fill.

Thanks for any help... I appreciate it

 

[Fluff]

Select the range of cells you want to format & in Conditional Formatting, Use a formula
=B2<today() for="" red
=B2=TODAY() for blue
=B2>TODAY() for yellow

 

[Fluff]

Just realised that the board ate the formulae, so I have corrected it.

 

[slparadise]

This worked perfectly... thanks for the help!!!

 

[Fluff]

You're welcome & thanks for the feedback