Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can i use cond formating to colour an entire column? Sully New Users to Excel 2 July 15th 08 07:22 PM
Conditional Formating an entire row cardosol Excel Discussion (Misc queries) 1 May 1st 08 10:06 PM
Conditonal Formating Excel 2007 - Duplicate Values jaclh2o Excel Worksheet Functions 0 November 20th 07 04:58 PM
Help using Conditional Formating of Entire Rows [email protected] Excel Worksheet Functions 4 February 16th 05 04:29 PM
How to change an entire row using conditional formating John Edwards Excel Discussion (Misc queries) 2 December 9th 04 05:41 PM


All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"