Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |