ExcelBanter - conditional formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - conditional formatting - color (https://www.excelbanter.com/excel-discussion-misc-queries/262955-conditional-formatting-color.html)

Anvil22

conditional formatting - color

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[_6_]

conditional formatting - color

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

"Anvil22" wrote:

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

Anvil22

conditional formatting - color

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

"Gary Brown" wrote:

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

"Anvil22" wrote:

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

Anvil22

conditional formatting - color

the N is in "n" - dick

"Gary Brown" wrote:

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

"Anvil22" wrote:

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

All times are GMT +1. The time now is 03:45 AM.