If you click on the Sequoia tab and go to A29 you will barely see a "0" has populated there from the formula I put in there. I am not sure why because I have an error trap, but anywho...If you look at the conditional formatting for that cell you will see I have 2 formulae in there. One for if the cell contains nothing, and one for if the cell contains a "0". Neither of those formulae are working. The value that populates in that cell originates on the "Top Census Sheet" and is pulled to the corrosponding cell on the Sequoia sheet. From there it is populated into A29 - the series for formulae to get the number there should not difficult to follow. I think my conditional formatting is not working because of the format of any of those three cells...I have tried formatting the cell for text, general, and number. I need it to display exactly what I type in because one of the values will be "1:1". What is missing from my conditional formatting that is making this simply not work at all?

RedEnddesens.xlsm