Help with Conditional Formatting

  • Thread starter Thread starter BigDreams7433
  • Start date Start date
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top