Conditional Format Help...
 

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.

Conditional Format Help...
 

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.