hi Ninjabear.. for one you cant put """" in the if statement unless you want it to display that text.. and imo it is better to have a cell saying 0.5 then the formula can say =IF(OR($G$5>G1,$G$5<G1),TRUE,FALSE) but this wont work in conditional so you need to use =OR($G$5>G1,$G$5<G1) on conditional formatting