Is it possible to pick up the <>= symbols from a cell for a conditional formatting?

[szita2000]

Hi guys.

I am trying to build a sheet where our management can set targets based on cell values, and the <,>,<=,>=,=symbols in another cell.

Here is my mock up for the conditional formula which does not evaluate at the moment.

I also tried to operate with the INDIRECT formula to pick up the symbols, but not working.
How can I do this?

This is what I tested so far, and if I evaluate the Logical test it gives me "1=0"
Can't get the MrExcel addon to work with the new forum, so quickly here is a table as an example. (Under the headers let's say this is row 2).

E	I	J	K
1	=IF($E2&($J$2&$K$2),1,0)	=	0

How can I write this formula so the value is picked up as a value from E2 then the rest of the evaluation as symbols inside of the IF?

 

[CountTepes]

IN conditional formatting , the formula would be written as:

=$E2={some value}

The condition has to be wither true or false. So if you put is =1=1 then you would have a true condition where as =1="Anything other than 1" will give a false.

So you could do something like: =$E2= ($J$2&$K$2)
And if $J$2="This is" and $K$2-"a test" then if $E2="This is a test" then the condition will not be met, but $E2="This isa test" the condition will be met.

Remember you need a true or a false condition.

 

[szita2000]

IN conditional formatting , the formula would be written as:

=$E2={some value}

The condition has to be wither true or false. So if you put is =1=1 then you would have a true condition where as =1="Anything other than 1" will give a false.

So you could do something like: =$E2= ($J$2&$K$2)
And if $J$2="This is" and $K$2-"a test" then if $E2="This is a test" then the condition will not be met, but $E2="This isa test" the condition will be met.

Remember you need a true or a false condition.

Hi CountTepes.
Unfortunately This does not work in my case.
I understand the basic principle of conditional formatting, but the goal of this would be so the equal, greater than, smaller than symbols are picked up from a cell. as well as the value that I want to evaluate to.

 

[CountTepes]

I assume by that that you mean E2 has a value, $K$2 has a value and $J$2 has a symbol ><=

In which case, set up 3 rules, one for each symbol and do the appropriate comparison for that symbol

I did it for A1,B1 and C1

=IF($B1="=",$A1=$C1)
=IF($B1="<",$A1<$C1)
=IF($B1=">",$A1>$C1)

In this instance it will only highlight in a specific colour, if the condition is true.

If they are all false then nothing will highlight

 

[szita2000]

I assume by that that you mean E2 has a value, $K$2 has a value and $J$2 has a symbol ><=

In which case, set up 3 rules, one for each symbol and do the appropriate comparison for that symbol

I did it for A1,B1 and C1

=IF($B1="=",$A1=$C1)
=IF($B1="<",$A1<$C1)
=IF($B1=">",$A1>$C1)

In this instance it will only highlight in a specific colour, if the condition is true.

If they are all false then nothing will highlight

Hi CountTepes!
This actually works! Thanks for the help.