Dear All,

Wonder if you can help me out and I apologise if this has already been asked but the forum search facility doesn't work I get an error message every time I search but can't find anywhere to let the site owners know and life's too short, ahem !

Simply how do I highlight a cell containing a specific formula on a large spreadsheet. So if cell contains formula A, colour it blue, if it contains formula B, colour it red, etc, etc. I have four formulae to differentiate.

I've seen tips on highlighting cells containing formula, but nothing on allowing a differentiation based on the actual formula itself.

Can anyone point me in the right direction?

Thanks,

Fraz.

PS Oh I'm using Excel for Mac 2011 if that helps.