Does any one know a way in which I can make cells appear (with formulas contained within them) based on a different cells value (if it is greater than) and if the cell contains a value that is less then the defined limit than the cells just don't appear at all.

I thought I could do this by assigning a macro that activates depending on the cells value (Im not really too sure about how to do this) and would it be easiest to just record this macro or to code it myself. I was also wondering if there was a possibility of doing this using conditional formatting.

Thanks