Macro to highlight statistically significant values

Hello!

I work with results from surveys, and I need to repeatedly highlight statistical significance skews. Obviously doing this manually leads to mistakes which lead to disaster. I would like help with writing a macro to run through a worksheet, and highlight all significant values in the worksheet with a specific colour (yellow). For this to happen there are a few things that need to occur:

1) Excel needs to calculate if values are statistically significant (multiple samples) or not (Z Number greater than 1,96 or less than -1,96)

2) If these values are significant, then the macro needs to highlight the relevant cells, as well as the cells that the proportions are relevant to.

Can anyone please help?
Gavin