Conditional Formatting Value_if_false

[Fountain]

Hello!

I'm sorry if this question has been answered elsewhere, though I couldn't find it if it had.

I'm using a logical formula that returns a number value based on whether the condition is true or not. The formula is like this: =IF(A1>A2,A2/A1,A1/A2) and works fine for me.

I want to use conditional formatting to highlight the cells which are false and subsequently use the part of the formula I have underlined to generate the number value.

Most of the guides I have found only tell me how to do this if the logical formula returns some text (i.e. "False").

Any help would be greatly appreciated.
If I have haven't been clear with anything, please let me know and I'll try to explain in more depth.

 

[JackDanIce]

Welcome to the board.

Assuming you mean what formula should the conditional formatting be to apply to cells where the FALSE part of your cell formula is evaluated, the CF formula is

=A1 < A2

That will evaluate as TRUE for the CF to then be applied to that cell

 

[Peter_SSs]

Welcome to the board.

Assuming you mean what formula should the conditional formatting be to apply to cells where the FALSE part of your cell formula is evaluated, the CF formula is

=A1 < A2

That will evaluate as TRUE for the CF to then be applied to that cell

Jack,
Wouldn't that be =A1<=A2?

 

[JackDanIce]

Sit corrected, yes it should to be the opposite of A1 > A2, thanks @Peter_SSs!

 

[Fountain]

Thanks you two. I can't believe I overlooked that solution - very simple.

 

[JackDanIce]

You're welcome