Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 25th 05, 12:16 PM posted to microsoft.public.excel.worksheet.functions
Gazivaldo
 
Posts: n/a
Default 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   Report Post  
Old November 25th 05, 01:10 PM posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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   Report Post  
Old November 25th 05, 02:19 PM posted to microsoft.public.excel.worksheet.functions
Gazivaldo
 
Posts: n/a
Default Colouring a row depending on data entered in a column


Brilliant. Thanks Bob. Worked a treat


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
displaying data within column iconic83 Charts and Charting in Excel 2 August 19th 05 12:11 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Can you average data in 1 column based on a range of values in another? kman24 Excel Worksheet Functions 2 November 17th 04 02:09 PM
How do I automatically shade cells depending on data entered? Jim Johnson Excel Worksheet Functions 6 October 29th 04 07:01 PM


All times are GMT +1. The time now is 06:41 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017