Conditional Format Help...

[j5b9721]

Conditional Format Help...
In cell EI7 I have a low price, and formula for the past 2 weeks and up
coming week.
=MIN(DS7W7,EB7:EF7,EK7:EO7)*EP6+MIN(DS7W7,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)
Re:
=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.

 

[Joel]

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.