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.