Use cell value as operation in conditional formatting

Is there a way to use the contents of a cell to evaluate conditional formatting?

For example; in cell [A1] I have the text ">5". In cell's [A2:A11] I have the numbers 1-10. How do I create a conditional formatting formula to use what's in cell [A1] to evaluate the condition of the other cells being >5?

And yes, I'm aware I could use "Format only cells that contain" and use "Cell Value, greater than, 5" as the parameters. However, the literal ">5" needs to be visible on the sheet, and the conditional formatting needs to update if the user changes ">5" to ">x"

As long as it will always be > you could use
=A2 >--MID(A$1,2,100)

But I don't think you can use the symbol from A1

Originally Posted by Fluff13

As long as it will always be > you could use
=A2 >--MID(A$1,2,100)

But I don't think you can use the symbol from A1

Thank you! That gave me enough to use the following:
=G7>=--RIGHT($G$4,LEN($G$4)-FIND(" ",$G$4))

Of course it'll only work so long as there is a SPACE between the operator and the number. I could not find a way to compensate for a missing space.

With the formula I supplied it doesn't matter if there is a space or not.
So if G4 contains >3, > 3, >11234 it will still work. (as long as the number is not more than 98 digits in length)

Originally Posted by Fluff13

With the formula I supplied it doesn't matter if there is a space or not.
So if G4 contains >3, > 3, >11234 it will still work. (as long as the number is not more than 98 digits in length)

Oh yeah... I was not thinking about the symbol - which will never be more than ONE character.

THANK YOU!

You're welcome & thanks for the feedback