Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Colouring a row depending on data entered in a column
Hi,
I'm working on spreadsheets like the example below. Basically I want the entire row to become shaded depending on the data entered in a particular column: #Coach ETA Rep Dest 105 0800 Jon AIME 106 0900 Marc CMF 107 0850 Jim AIME 108 0900 Pete LYS Basically, if either CMF or LYS show up in column 4, I want that entire row to be shaded. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Colouring a row depending on data entered in a column
Use conditional formatting with a formula of
=OR($D2="CMF",$D2="LYS") -- HTH RP (remove nothere from the email address if mailing direct) "Gazivaldo" wrote in message ... Hi, I'm working on spreadsheets like the example below. Basically I want the entire row to become shaded depending on the data entered in a particular column: #Coach ETA Rep Dest 105 0800 Jon AIME 106 0900 Marc CMF 107 0850 Jim AIME 108 0900 Pete LYS Basically, if either CMF or LYS show up in column 4, I want that entire row to be shaded. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Colouring a row depending on data entered in a column
Brilliant. Thanks Bob. Worked a treat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
displaying data within column | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
How do I automatically shade cells depending on data entered? | Excel Worksheet Functions |