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!
