conditional formatting for entire row

G

Guest

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.
 
D

David Biddulph

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.
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditonal Formating a entire row 2
CONDITIONAL FORMATTING- EXCEL 5
Highlight more than one entire row when cells = TRUE 5
Conditional Formatting Help 3
Conditional Formatting 2 rows only 2
Conditional formatting Entire Row Based on single Cell Value 5
Excel Highlighting duplicates 0
conditional formatting 3

Top