Sure you can do this. You would put an expression in the color property (if you want the text to change colors) or the background color property for the object you want to change. It would be something like this:
switch(Fields!total comparative.Value > 0, "green",
Fields!total comparative.Value -1, "yellow",
"Red")
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question