You may have already tried these, but here are some suggestions:
If your datasource type will allow, you could try pivoting all your fields into one,
then you could use one calculated field and list out all the conditions.
Alternatively you could try conditional formatting:
If these don't work, could you post a sample workbook?