[JethroUK©]

I am using excel as a datasource and merging this to create some
appointments for some students

{MERGEFIELD "CSCS_Test_DateTime"}

I need to make the appointments pending very distinct from the history (in
RED maybe?)

Any way i can do this?

{IF {Mergefield "CSCS_Test_DateTime"} Now()