title: Excel 2010 - Conditional formatting, color adjacent cells in same row
body: <p>Is is possible in Excel 2010 to set a conditional formatting rule to highlight all not empty cells in a row when the cell in particular column has a particular value?</p>
  
  <p>I have a  report in which every row identify a day. I would like to colour in grey the rows relative to Saturday and Sunday. The day is stored in column C.</p>
  
  <p>I know how to highlight cells in column C, but how can I easily extent the format of cell C to the adjacent not empty cells in the same row?</p>