Stumped on CF

[Len]

Hi,


I have the following formula in k37


=INDEX(Matrix,MATCH(I37,Consequence),MATCH(H37,Likelihood,0))


The Matrix table is

[pre]

Likelihood
0	5	   4	        3	   2	        1
1	Low	   Medium	High	   Very High    Very High
2	Low	   Medium	High	   High	        Very High
3	Very Low   Low	        Medium	   High	        High
4	Very Low   Very Low 	Low	   Medium	High
5	Very Low   Very Low 	Very Low   Low	        Medium

[/pre]
I am using Excel 2007


When I go to use conditional formatting for the following:

Very High = Red

High = Tan

Medium = Yellow

Low = Green

Very Low = Blue


I cannot get it to recognize Very High, it seems as if it will not recognize 2 words.


I have tried using exact text, but no luck.


Any help appreciated.


Len

 

[NARAYANK991]

Hi Len ,


I am not able to reproduce your problem ; everything works.


Check out this file :


https://www.dropbox.com/s/6l5zt9vvhh6g379/Len_Example.xlsx


Narayan

 

[bobhc]

Good day Len


You may have a problem in the fact that two words, low and high are in more the one form. Very Low and Very High, and High and Low and CF is picking up the Low and High from all instances and formating to the first instance rule. A two word format works.


Does this upload point in the right direction


https://dl.dropboxusercontent.com/u/34893656/Len.xlsx

 

[Len]

Hi All,


Thank you for the quick replies.


Narayank991, it worked when I copied your table over mine....


bobhc, your solution worked as well.


Once again thanks.


Len