conditional formatting - color

  • Thread starter Thread starter Anvil22
  • Start date Start date
A

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
 
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
 
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
 
the N is in "n" - dick

Gary Brown said:
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
Click to expand...
 
Back
Top