I have uses conditional formattiong to hilighte a cell if there is an N in
the cell:
=LEFT(A4,1)="n"
What I would like to do is hilight the row rather than just the cell.

Can anyone help
Thanks
Dick