Excel Conditional Formatting (Color Cell Based on their values)

Remove the double quotes in your CF formula. It then will work. When entering a CF formula you have to add the equal sign yourself, otherwise, XL puts it between double quotes.