Formula for CF
 

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
--

Formula for CF
 

Doug wrote:
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.)

Formula for CF
 

Worked great thanks!!!
--
Thank you!


"smartin" wrote:

Doug wrote:
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.)
.