Forum Discussion
Auto fill color in based on its value
Simple ask (I hope): I want to color an "average of total" cell at the bottom of a column populated with a number of 1 to 4. A different color for less than 2, between 2&3, between 3&4, and between 4...
=AND(A12>=2,A12<=3)You can try this rule for conditional formatting (yellow in the example).
=$A$12:$D$12This is the range the formatting applies to in the example.
I'm a novice (and I can't read German), could help with a step-by-step instruction?