I have used conditional formatting on an entire column to check a formula. The formula used is "if format is=W9=(P9-E9-Q9)" then format font red. It works for some cells but not others. When I check the same result using =if(W9=(P9-E9-Q9),"OK","Error". It does the same thing. I shows OK for some and notfor others. If I then check the results manually I get the right results for the entire column and it all checks out. With the first option I highlighted all the cells but removed absolute references and for the second method I copied and pasted.