First this statment can be simplifed
from
EK7<=(EI7*2%)+EI7

to
{=MIN(ABS(EK7:EO7-EI7))<=2%}

This is an array formula

The {} brackets are inserted automatically when you enter SHFt-CNTL-ENTER
after typing in the formula.

"j5b9721" wrote:

Conditional Format Help...
In cell EI7 I have a low price, and formula for the past 2 weeks and up
coming week.
=MIN(DS7:DW7,EB7:EF7,EK7:EO7)*EP6+MIN(DS7:DW7,EB7: EF7,EK7:EO7) cell format
-light green fill red text

EP6 is a weekly % increase or decrease of this week. (changes as days are
loged in)

In Conditional Format I have this... red fill & white bold text (for the up
coming week)
=OR(EK7<=(EI7*2%)+EI7,EL7<=(EI7*2%)+EI7,EM7<=(EI7* 2%)+EI7,EN7<=(EI7*2%)+EI7,EL7<=(EI7*2%)+EI7)

=OR(EK7<=(EI7*2%)+EI7,
EL7<=(EI7*2%)+EI7,
EM7<=(EI7*2%)+EI7,
EN7<=(EI7*2%)+EI7,
Eo7<=(EI7*2%)+EI7)
I need to know when the entered daily # is within <2% of EI7, need it to
check daily logging.

It activates before daily number are entered for the week, and dont clear
until the week is full.