conditional formatting of mergefield

Hello, I have a numeric merge field to be conditioned red for debit and default black for credit in a statement. The source data (in the EXCEL spreadsheet) has another merge field that is "CR" for c...