Colour scale HP Bar colors?

1
votes

I am attempting to use Color scale between two cells. The Right Cell is the maximum of the character's Hit points and the Left cell is their current Hit Points. I want it to scale between Red for less than 10%, Yellow if less than 65% and Green at 100%

But using the scale it shows as just Red to Yellow and then Pops in at full green value OR just stays red until it is 100% instead of scaling

HP Bar

Condition Information

2
google-sheetsgs-conditional-formatting

2 Answers

0
votes

I think you need a couple of (v. simple!) formulae:

SO54912815 example

Midpoint has been truncated and is actually:

=C$1*0.65

Change Minpoint from 0 to =C$1*0.1 if you prefer, but seems not necessary.

0
votes

use Number instead of Percentile where:

  • min: =C$1*0.1
  • mid: =C$1*0.65
  • max: =C$1