conditional formatting - color

[Anvil22]

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

 

[Gary Brown]

Say your data's in columns A thru Z
Highlight columns A thru Z
get into conditional formating
For a formula put...
=Left($a4,1)='n'

This will keep Excel looking at column A for comparison to 'n' yet will
highlight columns A thru Z

 

[Anvil22]

Gary,
Not sure what I am doing incorrectly. When I change the formula to read
=left($a4,1)=n the red fill color disappears, and the cells A4 throught d4
are not formatted with the color.

what did not do.
thanks
Dick

 

[Anvil22]

the N is in "n" - dick

Say your data's in columns A thru Z
Highlight columns A thru Z
get into conditional formating
For a formula put...
=Left($a4,1)='n'

This will keep Excel looking at column A for comparison to 'n' yet will
highlight columns A thru Z
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown