Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting color | Excel Worksheet Functions | |||
conditional formatting for tab color | Excel Worksheet Functions | |||
Conditional Formatting on Color | Excel Worksheet Functions | |||
Color Conditional Formatting | Excel Worksheet Functions | |||
Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) |