Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |