View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Dermot
 
Posts: n/a
Default Conditional Formatting...Please Advise

If I have a row of cells B6:M6
A cell K6 which is "List" validated Yes, No

I would like the full range of cells B6:M6 to become Yellow, when the cell
is set to Yes from the list.

I have experimanted with the "Conditional Formatting" dialogue box, but
can't work out how to do this....I can only get one cell to change to
yellow....that being K6 if I select yes from the list.

Please advise the correct way for me to achieve this objective.
Thanks