Conditonal Formating a entire row

S

shooter27

I have 400 rows of data x 30 columns 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 evertime a letter such as NR shows up in any of the four
specified columns, the entire row have 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.
 
F

FSt1

hi,
high light row 3 and enter this conditional fomat.....
=IF(OR($A$3="NR",$B$3="NR",$C$3="NR",$D$3="NR"),1,0)

adjust the cell references as needed.
works in xl03.

Regards
FSt1
 

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 format an entire row 1
Conditional Formating 2
Conditonal formatting problem! 1
Excel Conditonal Formatting Limits 1
Conditional formatting Entire Row Based on single Cell Value 5
Highlighting an entire row using conditional formating 5
Conditional format in a List 5

Top