Conditional format

[Mgarret]

Hi--

I have column with a bunch of records that indicate a rating level. The rating level is manually entered.

Column Responses look like this:

-2LOW 

12,very high                                                                                                                    

12-veryhigh  

3,moderate   

9,high- final risk rating very high 

0-Low    

risk score 11

LOW    

I would like to try and clean up the responses. Is there a way to make a conditional format that does something like this?:

If anywhere in the cell, there is a -2 = ‘Case Risk Rating: Low -2’

If anywhere in the cell, there is a 12 = ‘Case Risk Rating: Very High 12’

If anywhere in the cell, there is a 3 = ‘Case Risk Rating: Moderate 3’

If anywhere in the cell, there is a 9 = ‘Case Risk Rating: High 9’

If anywhere in the cell, there is a 0 = ‘Case Risk Rating: Low 0’

If anywhere in the cell, there is a 11 = ‘Case Risk Rating: Very High 11’

If anywhere in the cell, there is a LOW = ‘Case Risk Rating: Low’

99=SKIPPED

Thanks!

[art297]

Since there are some values that overlap (e.g., -2LOW, 0-Low, and LOW) is the order you listed the order of prescedence that you want applied?