View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Conditonal Formating a entire row

Check your post from 2 days ago - you have an answer there.

Pete

On Feb 9, 1:25*pm, shooter27
wrote:
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.