Conditional formatting sort of?

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

Is there a formula that can be written to highlight /
shade a row or column.

I know that conditional formatting is one way to do it
however, I am having difficulty writing a formula that
works.

On a spread sheet I have data in A11:S387, in column C is
either a "Y" or "N", if for example C12 is "N" I would
like to highlight / shade the entire all of row 12.

Any help would be appreciated.
 
Michelle

select row by clicking on the row number 12. Select Format | Conditional
Formatting...

Change Condition 1 to "Formula is" and in the box enter: =$C$12="N".

Select the formatting you want and click "OK"

Regards

Trevor
 
Back
Top