Conditional format an entire row

S

shooter27

I have 400 rows of data. There are four columns that contain any one of five
different key letters (R, NR, O, U, NA). What I want to do is that everytime
a letter such as NR shows up in any of the four columns, the entire row has a
conditional format applied. When I do "Cell Is", the conditional format is
only applied to the one cell even if I have the entire row(s) highlighted
when I create the conditional format. I tried to find similar posts to help
but have not been successful. Using Excel 2003
 

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

Conditional formating an entire row vs. only one cell 1
Conditional Formating 2
Conditonal Formating a entire row 2
Conditional formatting - highlight an entire row 1
Conditional Format an entire row 5
Excel Conditional Formatting 1
Conditional Formatting for Entire Row 2
Inserting a Copied Row inside a table 6

Top