Forum Discussion
Auto fill color in based on its value
=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've attached a sample file which should show everything in english on your computer.
Let's say you want to apply conditional formatting to cells A12:D12.
Then select the range A12:D12 with the mouse and then select "conditional format" (Bedingte Formatierung) -> "new rule" as shown in the screenshot.
Then "use a formula to determine which cells to format"
Then "format values where this formula is true"
After entering the rule for conditional formatting ( =UND(A12>=2;A12<=3) in the screenshot below, translated: =AND(A12>=2,A12<=3) ) you can click on format.
Then you can select the format and then click "Ok" two times.
- Thank you and danke schön!