Hi J Denault
Use the following calculation for the Conditional Formatting on the field, in Layout Mode highlight the fields you want to highlight and that can be as many as you want. Now go 'Format > Conditional...'
A dialog will appear, click on 'Add' and under the 'Conditional' options select 'Formula is' and input the following
Get ( CurrentDate ) ≥ TABLE::StartDate and Get ( CurrentDate ) ≤ TABLE::EndDate
Then under 'Format' click on the tick box next to 'Text Color:' and from the colour pallet icon choose Red.
Click 'OK' and that should do the trick.
I hope this helps
Thanks Orlando, I will give this a shot