Formula refresh

Hi,

If have formulas in cells that look to other cells to get an answer, but I have to manually use the F2 button as though I have made an edit to the cell and then leaving it, obviously Excel considers this a change and updates the cell and any Conditional formatting then kicks in.

Is there anyway I can write any code to do this over a large range of cells?

Thanks
Antony