I have entered this formula =IF(B18:F18<>3),"Error","Correct") but error is coming up.I have searched net to find solution but I'm getting nowhere.Across these columns I have results and I have manage that formula to work only on B18 :=IF(B18<>3,"Error","Correct"). I was also thinking is it possible to create formula that will make cell green when "correct",and red when "error"?