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