Hi folks, I am trying to formatt a group of cells in one block, A1-A3 across to G1-G3. I want the cell to go pink and bold when the number is 3 and below, any ideas because when I try, all the cells go pink, chhers.
I'm so close I can smell it !!! When there is no number in the cell it is filled in (pink) and when I enter a number below 3 it remains pink (which is what I want) and when a number higher than 3 is entered there is no fill (which is also good), how do I make it no fill when there is no number in the cell ?