I am trying to program a worksheet that formats cells (black) when you choose from a drop down box.

Column A is my choices
Row 1 are the item categories I need data
B2 to E6 is my data

So I choose "Car" from a drop down box in A2. I only need data in B2 and B4. I want the rest to be "blacked out"

If I choose "Truck" from the drop down box in A3. I need data in all cells.

If I choose "SUV" from the drop down box in A4. I only need data in D4 and all other cells are "blacked out".


I am very need to VBA programs so please help in the simplest terms.

Thank you very much.