Challenge #386: Shed Light on a Bank’s Risky Business

[KC]

My solution below:

Spoiler

 

[Bennu]

Another thumbs down challenge.  Don't attempt to reconcile against the solution because it will not match since the underlying data has issue as others have mentioned.  One simple formula is all you need..

Spoiler

If [Value]<[Amber Low] then
'Green'
elseif [Value]>[Amber High] then
'Red'
Else
'Amber'
endif

[SmitaLohande]

My Solution !

[rsphoenix02]

My attempt at the challenge.

[jfissel]

Spoiler

[Carolyn]

Solved!

Spoiler

[alineruizcampos]

Spoiler

[Erin]

Spoiler

[JBevan89]

Did it a non-macro way with formula and regex tools.  However, I have seen the solution and note that the macro solution could be useful in other instances