| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting for entire row
Hi,
If, in column Z, there is a letter "R," is there a way to highlight that entire row, not just the cell with the letter "R"? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting for entire row
Yes. Instead of using "Cell value is", use "Formula is"
=$Z1="R" Note the absolute addressing for the column, and relative addressing for the row. -- David Biddulph "h20polo" wrote in message ... Hi, If, in column Z, there is a letter "R," is there a way to highlight that entire row, not just the cell with the letter "R"? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting for entire row
Thanks David--I did and it works pretty well. The only thing is that it for
the most part only highlights the first letter of every column in the row. If I use the AutoFill option for a name that I've entered in more than once, then it highlights the entire word. Can I fix this? "David Biddulph" wrote: Yes. Instead of using "Cell value is", use "Formula is" =$Z1="R" Note the absolute addressing for the column, and relative addressing for the row. -- David Biddulph "h20polo" wrote in message ... Hi, If, in column Z, there is a letter "R," is there a way to highlight that entire row, not just the cell with the letter "R"? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use conditional formatting for an entire column? | Excel Discussion (Misc queries) | |||
| Conditional Formatting Entire Row | Excel Discussion (Misc queries) | |||
| 2007 Conditional Formatting entire row | Excel Discussion (Misc queries) | |||
| conditional formatting of entire rows | Excel Discussion (Misc queries) | |||
| Highlighting an entire row using conditional formatting. | Excel Worksheet Functions | |||
Linear Mode
