access field conditional formatting

I have a date field and a classdate field and a cancelled field.

I am trying to make the date field go red to show cancelled when the cancelled field says "cancelled" and the classdate (cancelled date) is same as date.

The code so far

[Date]=Format(Now(),"Short Date") And [Cancelled_Indicator]="Cancelled" And Format([ClassDate],"Short Date")=Format([(Date],"Short Date")

Select allOpen in new window

and for green (to show class ok to go ahead ie not cancelled)

[Date]=Format(Now(),"Short Date") And [Cancelled_Indicator]="Not Cancelled" And (Format([ClassDate],"Short Date")<>Format([(Date],"Short Date"))

Select allOpen in new window

I cant get it to work yet the form does start ok