IF Function Question

[cbnordy]

I would like to write a function that makes a cell show "YES" in green or "NO" in red. I know how to make it say yes/no but can you make the cell turn a shade or make the font turn a color based on referencing a value?

Here is my function:
=IF(F46>F44,"FAIL",IF(F46<F44,"OK"))

[BenjieLop]

I would like to write a function that makes a cell show "YES" in green or "NO" in red. I know how to make it say yes/no but can you make the cell turn a shade or make the font turn a color based on referencing a value?

Here is my function:

=IF(F46>F44,"FAIL",IF(F46<F44,"OK"))

I am trying to reconcile your first sentence with your formula.

Will your cell be "green for OK" and "red for FAIL" from your formula?

[cbnordy]

My cell is referencing two different value that do not have functions in them:
F46: =C21
F44: =C42

[cbnordy]

I figured it out due to the advice from JulieD on conditional formatting. Thanks JulieD and BenjieLop