All -

New here. This is my first post and it's because I'm stuck and confused.

Here is what I have:

I have:
1) first table (sheet 1) shows each individual sales item in its own row. Columns at the top illustrate various features, with the most important one (Authorization) showing "A" for authorized, "O" for Optional, "U" for Unauthorized.
2) a second table (sheet 2) shows each store in it's own row, with the items as columns. Sales data for each item, if it exists, is in the corresponding cell.

What I need is to conditionally format on the second table for each item's status at each store.
I need to show:
1. If the item is authorized ("A") but no sales (essentially a blank cell)
2. If the item isn't authorized ("U") either with or without sales
3. If the item is optional ("O") either with or without sales

My issue is in the conditional rule formatting. I believe that I will need to use an IF and VLOOKUP but having trouble orienting it well.

Ideas?