LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default Conditional Formatting

Hello

I am trying to highlight in yellow specific cells on a worksheet when I pull up a word from a list,
am having trouble in accomplishing the following task:

In cell B6 I have a list of 14 world markets (countries) we trade in.
When one of these is selected I would like to highlight the following cells that respectfully match that market.

M O R S T U

2 Hong Kong 9:58 AM HKD / CAD 6.349 HKD / USD 7.7984
3 Singapore 9:58 AM SGD / CAD 1.3274 SGD / USD 1.6305
4 Japan 10:58 AM JPY / CAD 83.476 JPY / USD 102.53
5 Australia 12:58 PM CAD/ AUD 0.9337 " " " "
6 New Zealand 2:58 PM " " " " " " " "
7 Thailand 8:58 AM " " " " " " " "
8 South Africa 3:58 AM " " " "
9 Switzerland 2:58 AM
10 Sweden 2:58 AM
11 Denmark 2:58 AM
12 Norway 2:58 AM
13 U. K. 1:58 AM
14 Finland 3:58 AM
15 E. U. 2:58 AM

For example when Japan is selected in cell B6 it has the effect of highlighting in yellow cells: M4, O4, R4:U4

Thank you

Susan

 
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
Conditional formatting--different formatting depending on cell con Tammy S. Excel Discussion (Misc queries) 3 March 30th 09 08:11 PM
Formatting cells in a column with conditional formatting? shamor Excel Discussion (Misc queries) 8 May 19th 08 10:11 PM
Protect Cell Formatting including Conditional Formatting Mick Jennings Excel Discussion (Misc queries) 5 November 13th 07 05:32 PM
conditional Formatting based on cell formatting Totom Excel Worksheet Functions 3 January 20th 07 02:02 PM
Conditional Formatting that will display conditional data BrainFart Excel Worksheet Functions 1 September 13th 05 05:45 PM


All times are GMT +1. The time now is 11:15 AM.

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"