Formula for CF

[Doug]

I am using this formula in CF to show a change in price +/- 2% between 2
columns.
Only problem is, it highlights all the blank cells as well. Any idea how to
fix it?
=(MAX($F3,$AB3)/MIN($F3,$AB3))<1.02
--

 

[smartin]

I am using this formula in CF to show a change in price +/- 2% between 2
columns.
Only problem is, it highlights all the blank cells as well. Any idea how to
fix it?
=(MAX($F3,$AB3)/MIN($F3,$AB3))<1.02

Try this:

=AND(NOT(ISBLANK(F3)),(MAX($F3,$AB3)/MIN($F3,$AB3))<1.02)

Or maybe:

=AND(ISNUMBER(F3),(MAX($F3,$AB3)/MIN($F3,$AB3))<1.02)

(Highlight F3:AB3 with F3 active when you insert the CF formula.)

 

[Doug]

Worked great thanks!!!
--
Thank you!

Try this:

=AND(NOT(ISBLANK(F3)),(MAX($F3,$AB3)/MIN($F3,$AB3))<1.02)

Or maybe:

=AND(ISNUMBER(F3),(MAX($F3,$AB3)/MIN($F3,$AB3))<1.02)

(Highlight F3:AB3 with F3 active when you insert the CF formula.)
.