Change color of a cell if value in other cell is not the same.

brohera - Jun 20, 2016 at 03:20 PM

I want to be able to change the color of a cell to red if the value in another cell is different. e.g if cell A1 is $0 and cell AF is $5 then change the value of cell A1 to red color. I have Excel 2010