Conditional Formatting on Column not listed in Crosstab Query

[AdamAA]

I have a simple crosstab query:

FirstName and Surname as Row Headings.
Date as Column Heading.
OnShift as a Value (Count).

These are from the table DailyActivityLogs. Also in that table is a choice field called Weather that lets you choose the conditions that day (Weather, Work, Part Weather, Subbed).

This is the report the crosstab query generates:

What I would like to do is colour the Count fields depending on what the weather was that day. It seems possible, as Weather sits in the same table, but the field Weather isn't in the crosstab query.

Can I do this?

 

[AdamAA]

Thanks Pat! So what would I put in the "Total" part of the query for Weather to get it to return the value of the field? 'Group By', 'Sum', 'Min', Max' etc. all seem like they'd return a numerical value instead of the actual value of the field.