Adding a conditional text color to a numeric formula field.
Hello,
I've rather new, and have searched but cannot seem to find the right combination to colorize the text of a numeric formula filed if selections are made in another field. We are generating an Authorization Number based on the selection of [Authorization Type].
Here is the formula I'm using, I just want to add a color to each selection. For instance if the selection is "PPO Approved" I'd like the color to be green, "Out of Network Approved", red. Down the line I may also want to add additional colors to other selections.
------------------------------
Chris Hesenflow
------------------------------
I've rather new, and have searched but cannot seem to find the right combination to colorize the text of a numeric formula filed if selections are made in another field. We are generating an Authorization Number based on the selection of [Authorization Type].
Here is the formula I'm using, I just want to add a color to each selection. For instance if the selection is "PPO Approved" I'd like the color to be green, "Out of Network Approved", red. Down the line I may also want to add additional colors to other selections.
Case([Authorization Type], "PPO Approved", [Record ID#]+60078965, "Out of Network Approved", [Record ID#]+70078965, null)
Hope that makes sense.
Thank you in advance. I'm probably missing something rather simple.
------------------------------
Chris Hesenflow
------------------------------
