Conditional Formatting based on Row values not Column

Hi Everyone,

I'm trying to make a pivot table like this and when i try to use conditional formatting it applies the formatting based on columns like this:

what i'm trying to do is to make conditional formatting only look at the values on each row separate.

for example i want it to look like this

is there any work around to this

I think you are looking for this

1 Like

yea something like this

Hi TonyC, I need some help.

I would like to know if it is possible to add colors using a customized conditional formatting, as it isn’t feasible in this print format because the conditions are interpreted separately.

Basically, I would like to apply conditional formatting for a range, for example: greater than 79 and less than or equal to 100.

Since I added two separate conditions in the conditional formatting here, it does not meet the solution because it marks everything less than 100 and everything greater than 79 in blue.

Thanks for the support.