Last answered:

27 Jun 2023

Posted on:

08 Oct 2022

0

Conditional Formatting

Why did we use 0.1 and 0 as a range for conditional formatting ?



image.png

2 answers ( 0 marked as helpful)
Instructor
Posted on:

10 Oct 2022

2

Hello,
These values are typically chosen based on the user's discretion.
Best,
Ned

Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

27 Jun 2023

0

In the example, the user chose a threshold range of 0%-10%.  Because the format was a number, the input has to be 0 and 0.10.  However, these numbers are arbitrary as it depends on what end users need the threshold to be.  The example could have easily been 0%-50% or even -5%-25%.   It just depends on usage and company expectations.

Submit an answer