Conditional Formatting on a Single Value in a Field

[wdwiz4]

Hi all!

I've been banging my head for the past day trying to figure out something and was hoping I could get some help.

We have a crosstab report that needs to highlight a threshold on a value within a field. For example, the field, Procurement, has three values: Commodities, Other Services, and Prof Services. The request is to only have a threshold on the Other Services when it falls below 6%. I can easily do this on the column itself but it will highlight all values(Commodities, Other Services, and Prof Services) that fall under 6%.

Any assistance would be greatly appreciated.

Thanks

[New_Guy]

Hi,
Have you tried to apply conditional styles on fact cells like [Query1].[procurement] = 'Other Services' and [measure] < 6. Let us know if this works.
Good luck