Conditional Formatting Question

[bamalovell5]

So I am trying to figure out how to conditional format a number for each time it gains or looses a percent it gets Greener or Redder.

Basically if its at 1% its dark red and then at 5% it gets a little Lighter Red and then at 100% its Green.

Is there a way to do that?

 

[Jeffrey Mahoney]

You need a baseline cell which is the last value of the primary cell. How you update that cell is up to you. You can use a macro. Since formula results don't trigger any kind of event, you're going to have to decide when you need to save your baseline and run the macro to copy the value to the baseline cell.

Now here comes the tedious part. Conditional Formatting (CF) rules for colored scales doesn't work very well. You're going to have to add, say 5 - 10 rules, where each rule is a color based on the percentage of the baseline.