Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I have matrix consisting of values between [No Value] - 100. I want to apply conditional formatting to show Red colors to 0.01 and white color at 0. But i cannot get it to work if i type in my numbers.
If i select formatting like this:
Minimum - Number - 0.1
Center - Middle Value
Maximum - Highest Value
it stops rendering colors completely. If i type all value as numbers then cells with NO VALUES(not zero) render as lowest possible even when it should stop at 1 or 0.1.
Is there a fix for this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.