Conditional formatting on date entry

I want to conditional format cell when I enter date that will change after the date has passed
ie. Oct-16 entered

on Oct 16 cell is filled green
on Oct 17 cell will fill red until the cell beside it has a entry

This is what I have so far I haven't added where the cell goes back to green when the cell beside has an entry

="IF(H3=TODAY())"

Hi there,

Have a look at the Conditional Formatting used in the attached workbook and see if it does what you need.

Hope this helps - please let me know how you get on.

Regards,

Greg M

this very close
I want the color in B3 to change to red if the date entered in C3 is >B3
and Green if =<B3

Originally Posted by JeteMc

Rule #1: =AND(C3<>"",C3<=B3) [Green]
Rule #2: =C3>B3 [Red]
Rule #3: =B3=Today() [Green]
Rule #4: =AND(B3<>"",B3< TODAY()) [Red]

If the above works (didn't check), this should too:

Rule 1: =OR(AND(C3<>"",C3<=B3),B3=Today()) [Green]
Rule 2: =OR(C3>B3,AND(B3<>"",B3< TODAY())) [Red]