Hello,
I hope I can explain this correctly. I have a Pivot table that lists all the items on order for several customers. The Items on order need to be in Shelf Quantities. (Example RED BALL Shelf Qty is 10. Orders that are not 10,20,30,etc. should highlight in RED) The shelf quantities for each item are listed in a table in a separate sheet. I want to highlight in red all the items that are not in correct shelf quantities. I have everything except the highlight part.
Thanks in advance to anybody who can help,
Scott
I hope I can explain this correctly. I have a Pivot table that lists all the items on order for several customers. The Items on order need to be in Shelf Quantities. (Example RED BALL Shelf Qty is 10. Orders that are not 10,20,30,etc. should highlight in RED) The shelf quantities for each item are listed in a table in a separate sheet. I want to highlight in red all the items that are not in correct shelf quantities. I have everything except the highlight part.
Thanks in advance to anybody who can help,
Scott