Helloitsme
New Member
- Joined
- Feb 19, 2021
- Messages
- 28
- Office Version
- 365
- Platform
- Windows
I'm trying to use conditional formatting to compare a static value with a dynamic value that will be updated daily. Whenever I try to use the conditional formatting, it compares to the first cell chosen rather than the one it should compare to. The table will contain 50 items if not more.
Please see below, AG, AI, and AK are the dynamic values:
Please see below, AG, AI, and AK are the dynamic values:
Kollektion.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | |||
6 | Eros | Eau de Parfum | 50 | SP-673566 | 46.57 | 60.1206 | 10 | 100 | 4 days | 4 days | ||
7 | Eros | Eau de Parfum | 100 | SP-673565 | 57.54 | 71.6519 | 63 | 65 | 3 days | 3 days | ||
8 | Eros | Eau de Parfum | 200 | SP-707021 | 83.55 | 103.124 | 108 | 102 | 3 days | 3 days | ||
9 | Eros | Eau de Toilette | 30 | SP-208326 | 52.11 | 64.9606 | 500 | 500 | 4 days | 4 days | ||
Overview |
Cell Formulas | ||
---|---|---|
Range | Formula | |
AG6:AG9 | AG6 | =SUM((VLOOKUP(AE6,'Stock Perfume'!E:R,12,FALSE)*1.21),8.15,2,1.74) |
AI6:AI9 | AI6 | =VLOOKUP(AE6,'Stock Perfume'!E:R,11,FALSE) |
AK6:AK9 | AK6 | =VLOOKUP(AE6,'Stock Perfume'!E:R,14,FALSE) |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
AK6:AK27 | Cell Value | <$AJ$6 | text | NO |
AK6:AK27 | Cell Value | >$AJ$6 | text | NO |
AK6:AK27 | Cell Value | <$AJ$6 | text | NO |
AK6:AK27 | Cell Value | >$AJ$6 | text | NO |
AI6:AI27 | Cell Value | <$AH$6 | text | NO |
AG6:AG27 | Cell Value | <$AF$6 | text | NO |
AI6:AI27 | Cell Value | >$AH$6 | text | NO |
AG6:AG27 | Cell Value | >$AF$6 | text | NO |