1

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

player0
  • 124,011
  • 12
  • 67
  • 124
HummBird
  • 51
  • 8

1 Answers1

2

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

player0
  • 124,011
  • 12
  • 67
  • 124