Conditional formatting

[Kemidan2014]

Google is evading me on giving me the answer i need and i feel like the answer is so simple that ive forgotten

We want to conditionally format the results of cells that have formulas for 3 colors 0 = green, 1 and 2 = orange, if the result is equal to or greater than 3 = Red.

i know i can make 3 seperate rules but could this be done with the 3 color scale so theres only 1 applied rule? adding =">=3" is not working for example if i select formula.

 

[Deek6t8]

If you use a colour scale on the cells then edit the rule and specify the options you need based on the cell values as per attached image.

 

[etaf]

1 and 2 = orange,

this may be your issue as 1 and 2 will shade ....

 

[Deek6t8]

this may be your issue as 1 and 2 will shade ....

doesn't work that way for me

 

[Fluff]

doesn't work that way for me

Both 1 & 2 should be orange, with 0 as green.

 

[Kemidan2014]

I think we all agree lowest value should be set to "Number" as 0
but i feel like middle value and highest should be "Formula"s i just cant think of the correct syntax

 

[Deek6t8]

Ah sorry I misread the original post you are right apologies

 

[Fluff]

As etaf has said, it's the 1 & 2 that are the problem, as they will not be orange. The Green & Red are no problem.

 

[Kemidan2014]

I think im happy with this!
SO all i did was adjust Deeks original set up for middle number to be 1 instead and it works out. 1 and 2 are 2 slightly different colors but i htink management can accept this.

 

[etaf]

or just use 3 rules and have exactly what you need