Conditional Formatting Matrix

[StuartScott]

Hello all

I am really having trouble getting some conditional formatting onto a matrix table.

Here is the table, the data a count of students being shown as a percent of row total. what I want to do is change the background colour if any of the cells are above 50%..

Everything I have tried just does not work. Any advice would be very much appreciated.

Thanks

[mlsx4 · Accepted solution]

How are you defining the rules in the conditional formatting? As you may know it is an option to use percentage and number. I always use number and instead of writing 50%, I write 0.5.