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
Bookmarks