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.

Inspection	Date
Plumbing	4/14/2019
Electric	4/16/2019
Decking	4/18/2019
Final

<tbody>
</tbody>

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