| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i use cond formating to colour an entire column? | New Users to Excel | |||
| Conditional Formating an entire row | Excel Discussion (Misc queries) | |||
| Conditonal Formating Excel 2007 - Duplicate Values | Excel Worksheet Functions | |||
| Help using Conditional Formating of Entire Rows | Excel Worksheet Functions | |||
| How to change an entire row using conditional formating | Excel Discussion (Misc queries) | |||
Threaded Mode
