Excel - Change cell color based on value of another cell
Posted on 2013-06-29
I am running Office 2000 on an HP z210 running Windows 7 Pro.
I have an Excel spreadsheet. In it is a cell containing a date. The cell is A1
I have another cell which tracks price changes. The cell is D1
In A1 I have conditional formatting . The formula is =D$1$<10.00. The cell turns red when this condition is true.
I'd like to have cell A1 turn orange if the price is < 5.00 . But my guess is the logic of the conditional format would get confused. A price which is < 5 is also < 10.
I am not an Excel expert. What would you do to get cell A1 to turn orange when the price is < 5 and turn red if the cell is < 10 but greater than 5? Please give me a detailed answer.
Thank you for your help.