Search code examples
if-statementgoogle-sheetsmaxmatchconditional-formatting

Conditional Format based on scenario of another Cell

Please help change color scale - conditional formatting

B2 = 60 (fixed value)

If B2 = 10 (daily count) then B2 = Green BG

(based on percentage - 1 to 60 )

Min = Green , Mid = Orange, Max and above = Red

enter image description here

Solution

  • Min = Green , Mid = Orange, Max and above = Red

    literally, try:

    1
30
60

    enter image description here

    update:

    1

=(B2-(B3/B2))/1.1

=B2-(B3/B2)

    enter image description here