Help with Conditional Formatting

B

BigDreams7433

I have a problem with a spreadsheet Im doing, heres an example:

Cell A1 has a drop down list containing X & N/A
When you select N/A from the drop down I want cell A1 and about 4 or 5 cells
in the same row next to A1 to turn gray.
I also want cells on the row below to turn gray

How do I accomplish this?
 
Top