RecipeDan
asked on
Background Color based on Column Value
Hello:
I want a background color in a column based upon a value in another column. When I use the script below, it shows the actual word instead of the color. When I delete the quotation marks from the color, I get an error.
I want a background color in a column based upon a value in another column. When I use the script below, it shows the actual word instead of the color. When I delete the quotation marks from the color, I get an error.
=Switch(Fields!OCT.Value >= Fields!CPGTarget.Value, "Green",Fields!OCT.Value< Fields!CPGTarget.Value, "Red")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
thanks for the grade. Good luck with your project. -Jim
ASKER