Skip to Content
0

Conditional formatting within table

Jan 30, 2017 at 09:27 PM

78

avatar image

Hi, I have a report where I want to create flags where we have orders of an old item number when there is inventory available of a new item number.

The report is sectioned out by plant location. Reports will have multiple old and new item numbers. What I want is to tie the flag between a specific old item number and a specific new item number. The tables also show current inventory, current orders, inventory after orders, MTD sales, and scheduled production.

So for instance, if there is item A1 (old), item A2 (new), item B1 (old), and item B2 (new) within each plant, I want for the formatting rules to specifically show a special format when there are current of A2 when there is current inventory of A1 available. And I want this specific between items A1 and A2, ignoring items B1 and B2.

Any help is greatly appreciated!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers