Compare values in two cells, plus conditional formating

[paparazzi88]

I have a situation that I need to compare a price from one given cell to a value of another cell, and decide if the price is higher or lower than the value in the first cell. After that, conditional formating needs to be applied.
Example: Proper price for the product is $2.00, but the bid is $1.95. When I enter the value of $1.95 the cell needs to become red, alerting me that I am going under price.
If it's possible the alert needs to go over a range of colors from red, orange, yellow, blue, green....for different differences from -$0.05 to +$0.05.

Thank you for any help

[mrice]

In conditional formatting, use a formula as the criterion.

e.g. =$A$1-$B$1> 0

[paparazzi88]

Thought of that, but need more than 3 conditions, and couldn't figure it out the "Case" part in the VBA for more than 3 conditions. How to implement a forumula in that.