 • 509K Members
• 6,991 Online
• 606K Conversations

# 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
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
conditional formatting with formula
kdwork in Excel on
3 Replies
Conditional Formatting - Consider Only Value as Lowest Value
Ben Smith in Excel on
2 Replies
Date Formatting Won't Change
Steve Gould in Excel on
10 Replies
Format Date in header and footer
Joe Cangelosi in Excel on
3 Replies