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 |
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 |
Colouring a row depending on data entered in a column
Brilliant. Thanks Bob. Worked a treat |
All times are GMT +1. The time now is 04:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com