cancel
Showing results for 
Search instead for 
Did you mean: 

Matrix Conditional Formatting problem

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?

Status: Needs Info
Comments
Microsoft

@atomek1000

 

I’m not very clear about your requirement. For following table, what are the colors do you want to be shown in them?

 

Matrix Conditional Formatting problem_1.jpg

 

Best Regards,

Herbert

Impactful Individual
Status changed to: Needs Info
 
New Member

I think have a similar problem.  I need to simply set a fixed color at a fixed threshold.  In other words, all values 1 and above show as Green, and all values up to 0.99 show as white.  No need for gradient color gradually fading into a middle value and then to the upper value.

 

I thought this should be quite straightforward.  We may need to create a case and get voting.

Frequent Visitor

Hi,

 

Any one could help on this:

 

I need color coding in matrix with values >=60 as Green and <60 as Red.
I am getting fixed colors for fixed number instead of a range of values.
Please help!

 

Thx

Advocate I

Thats partially what i was requesting. Good idea to raise some issue