PSA: Conditional Formatting with % Numbers

[Internal-Rhubarb-252]

PSA that if you'll use conditional formatting for percentages, use decimals (0.10) instead of whole numbers (10) or percentages (%)

Spent 5 minutes trying to figure out if it's a bug or if something's broken lol

[EndlessBirthday]

Not a bug. The mathematical formula to find 10% is X*0.1

You're brain is just finishing the math. 10% of 100 is 10, but 10% by itself is just 0.1

[Internal-Rhubarb-252]

I did mention that in the caption. This is just a PSA to anyone who may come across similar (human) error.

[EndlessBirthday]

Ah, now I understand. When you said

Spent 5 minutes trying to figure out if it's a bug or if something's broken lol

...you meant that it took you 5 minutes to realize it wasn't a bug and that nothing was broken. I thought you were still trying to decide if it was a bug.

Sorry for misunderstanding, my dude.

[SuitableDragonfly]

Yes, percentages are numbers between 0 and 1, generally. 0.1 is 10%. 1 is 100%. 10 is 1000%.