killerflappy
Registered User.
- Local time
- Today, 22:51
- Joined
- Aug 23, 2017
- Messages
- 50
Hi guys,
I’m struggeling with a condition formatting expression.
I have a table with the colums shopnumber, product, quantity, remark. Like:
1000 A 2 stock
1001 A 2
345 B 1 stock
1000 C 1
1001 A 1
1000 C 1
Then I have a crosstable query that sums up the quantity of the same products per shopnumber. Colums shopnumber, product A, product B and product C Result (no remark):
1000 2 0 2
1001 3 0 0
345 0 1 0
Now I want to make a conditional format on a column (for example the shopnumer) where it gets a colour if there is the remark “stock” for the shopnumber in the filst table. So 1000 and 345 should get a colour.
I searched the internet and tried to work with DCOUNT and DLOOKUP, but no success.
Can someone put me in the right direction?
I’m struggeling with a condition formatting expression.
I have a table with the colums shopnumber, product, quantity, remark. Like:
1000 A 2 stock
1001 A 2
345 B 1 stock
1000 C 1
1001 A 1
1000 C 1
Then I have a crosstable query that sums up the quantity of the same products per shopnumber. Colums shopnumber, product A, product B and product C Result (no remark):
1000 2 0 2
1001 3 0 0
345 0 1 0
Now I want to make a conditional format on a column (for example the shopnumer) where it gets a colour if there is the remark “stock” for the shopnumber in the filst table. So 1000 and 345 should get a colour.
I searched the internet and tried to work with DCOUNT and DLOOKUP, but no success.
Can someone put me in the right direction?