Help with Conditional Formatting
 

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?

Help with Conditional Formatting
 

See your other post

--
Biff
Microsoft Excel MVP


"BigDreams7433" wrote in message
...
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?