Need help with a conditional formatting formula

[SEMMatt]

Can anyone help me with an if/else conditional formatting statement. I want text to be red if A1 < A2 and green if A1=< A2.


Thank you,

[popipipo]

There is not much difference between those 2 statements
CF formula for red color =A1<A2
CF formula for green color =A1<=A2

[tigeravatar]

Is it supposed to be green if A1 is greater than or equal to A2? Because right now you have as green if A1 is less than or equal to A2. And with the red one being A1 less than A2, the only greens will be those where A1 is exactly equal to A2.

[SEMMatt]

I want green if A1 is greater than A2 and red if it's less. Nothing if it's the same (black). How can I do that? Thanks!

[Ace_XL]

Two conditions

=A1>A2
format green

=A1<A2
format red

[SEMMatt]

conditional formatting 2.xlsx

but how do I write than in an Excel formula, how do I separate those two statements? attaching a worksheet for example. I want A1 to be green and A2 to be red.

-thanks

[Ace_XL]

See attached

[SEMMatt]

Sorry I wasn't clear but you changed the metrics. I want A1 to be 1,000, A2 to be 2,000, B1 to be 2,000 and B2 to be 1,000. Just need a simple formula to make data in column A red/green if it's less/greater to B.