Max and Pete thank you both for your replies.

Max - Your method works great however if I continue to add formulas to the worksheet I would need to keep repeating this each time. Is ther a way to automate this so that if I add a formula to a cell it will automatically format the text?

Pete - To use conditional formatting, what formula works best to test if a cell is a formula or not?