COnditional format cell based on results from a formula

[temakhafola]

Hi All,

This is a formula I used =IF(C11<=2;"1";IF(C11=3;"2";if(C11>=4;"3"))), I now want to conditionally format the cells based on the results of this formula like if I get 1 the cell must be red, if 2 the cell must amber and if I get 3 then the cell must be green.

 

[philwojo]

You will need to break it out into 3 CF items. Then just split out your 3 formulas an apply the colors (formatting) you want based upon a true result.

So for the 1st one as an example you could put this into your CF formula:

=C11<=2

Then set the formatting based on that being true.

Then do the other 2 formulas as a 2nd and 3rd CF formula test.

Phil

 

[kweaver]

Am I missing something? Why wouldn't you select the range and apply the 3 types of conditional formatting?

 

[Garden Utopia Productions]

Conditional formatting doesn't work that way unfortunately. You can only pick one color per rule/condition. That rule can still apply to the full range. So like Phil said, you need to split this formula up into 3 separate rules.

 

[kweaver]

I have three rules here...what am I not understanding?

 

[philwojo]

Kweaver, you can only test for a True/False as part of CF, so from my understanding you can't use an IF statement for that. Plus we can only implement one formatting type for a T/F result so how would you select different colors in 1 CF test? The answer is you can't that is why you need the 3 CF formulas so you can apply the different colors, hope that makes sense.

I hope we helped the OP as well.