• 548K Members
• 6,257 Online
• 654K Conversations

Highlighted
New Contributor

# contitional formatting with function IF

Hello,

I´m trying color cells (Green-yellow-red) considering the value in it, for that, I added 3 rules, one colour each, but depending also from the sign in another cell.

That means, if the sign in the formula as a text, matches the sign in cell L15, then operate and give a color, if not, then compare the next condition, and so on...

My problem is that the second condition (<= ) of the formula does not operates.

Is it correct to use the conditional like this ?

Green:

=SI(L15="≥",T15>=S15,SI(L15="≤",T15<=S15,SI(L15="=",T15=S15)))

Yellow:

=SI(L15="≥",T15>=0.9*S15,SI(L15="≤ ",T15<=1.1*S15))

Red:

=SI(L15="≥",T15<0.9*S15,SI(L15="≤",T15>1.1*S15,SI(L15="=",T15<=S15)))

Alejandro

2 Replies
Highlighted

# Re: contitional formatting with function IF

@Alejandro1963 , in general formula works if you mean like this

Another story you will never check third condition (=) since you start from "greater or equal". Start checking from "equal" as in the second variant.

# Re: contitional formatting with function IF

Hi Sergei,

Thank you for your time, as you said, the formula worked but searching why it didn´t I realised I wrote in two different ways the text to be compared, "≤ " didn´t match to "≤" because the first text on the column had a space-tab after the symbol and in the formula it didn´t have that space.

These hidden orthographic mistakes are to be taken into account.

Regards

Alejandro

Related Conversations
Make Share function in Edge more useful
HotCakeX in Discussions on
2 Replies
Cell Validation - Drop Down Lists and Text Formatting
JenSmith in Excel on
1 Replies
function talking to table storage
donquijote in Compute on
0 Replies
Calculated column help
gopalaraoa in SharePoint on
1 Replies