James,

You asked the same question yesterday and got two replies. Did you not
see those or did they not work for you.

Peter.

Turn red only if the date  field equals the date? Not before nor
after?

Select the Date field.
Click on Format + Conditional Formatting.
Set Condition1 to:
FieldValue Is
Select
equal to
Enter
Date()
in the next box.

Select the Red color from the tool button list.
Save the changes.

Select the other 2 controls.
Go to Conditional Formatting as above.
For Condition1 select
Expression Is
Write
[DateFieldName] = Date()

Select the Red color.

Save the changes.