It worked previously, but all of a sudden it's showing the wrong color. Before you ask, there are no percentages and fractions. Just additions and subtractions of cash. I'm trying to do this: if A = B, shade with light green fill with dark green text; if A <> B, shade with light red fill with dark red text.
But... when A = B, I'm getting a light red fill and dark red text. Why? A <> B works fine.
I'm just staring at the Conditional Formatting Rules Manager and can't wrap my mind around this.
But... when A = B, I'm getting a light red fill and dark red text. Why? A <> B works fine.
I'm just staring at the Conditional Formatting Rules Manager and can't wrap my mind around this.