How do I conditionally format a cell to turn multiple colors for different conditions?

M. Wolf

I want a cell to turn yellow if it equals $0.00 and red if it's less than $0.00, I've tried to add a new rule but it doesn't apply the rule for the less than $0.00 condition. What am I doing incorrectly?

M. Wolf

I got it to work now, I completely erased and started over and formatted it the way you have it listed above. Thank you!

MichaelTCA

@M. Wolf

It's hard to tell without seeing all the conditional formats and where they are located in the list.

1. You need to move the most critical formats to the top and the least critical to the bottom.
2. The condition for "green" is not set up as you anticipated.

M. Wolf

These are the only two conditions that pertain to this column. I made the color of the column green.

MichaelTCA

@M. Wolf If it's set up like this (below), it should work. Otherwise, there has to be another condition influencing it.

M. Wolf

I got it to work now, I completely erased and started over and formatted it the way you have it listed above. Thank you!