Conditional formating an entire row vs. only one cell

  • Thread starter Thread starter shooter27
  • Start date Start date
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 that meets the condition 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.
 
Highlight all your data (assuming you have started in row 2 and that
A2 is the active cell of the selected range), then click on Format |
Conditional Formatting and choose Formula Is rather than Cell Value Is
in the first box. Put this formula in the formula box:

=COUNTIF(2:2,"NR")>=1

then click on the Format button and set your format (eg Patterns tab,
choose red). Click OK twice to exit the dialogue boxes.

Hope this helps.

Pete
 
Back
Top