Conditional format

Frequent Contributor
Posts: 144

Conditional format

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!

PROC Star
Posts: 8,169

Conditional format

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?

Discussion stats