View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BigDreams7433 BigDreams7433 is offline
external usenet poster
 
Posts: 3
Default Help with Conditional Formatting

I am new to Excel and know a little, but I cant figure out conditional
formatting.

Im doing a worksheet for my job and I need a group of cells in a row to
change colors based on what is entered in a certain cell. For example:

Cell A1 has a drop down list contatining X & N/A
If N/A is selected from that list I want cell A1 and about 4 or 5 cells next
to it on the same row to turn gray.
This could also include not only the 4 or 5 cells next to A1 but possibly
the row below that.

Is this possible? If so, how do I do it?