certain number in a cell? im not sure how to use conditional formatting here is the formula i have at the moment i have put this in to the coditionnal formating section on the cells i want to turn green =IF($G$27="120",TRUE,FALSE) the cell where the number will be that reaches the target is G27 and when it reaches the target 120 i need help!!!