Autoformatting a cell to show it contains a formula

[pshclark]

Is it possible to autoformat cells, or in some other way automatically indicate that a cell contains a formula? I normally just make all cells with inputs one colour and those with formulas another, but I wondered if I could do this automatically?

thanks a lot

paul

 

[Krishnakumar]

Hi Paul,

Welcome to the MrExcel Board!

Click here

 

[pshclark]

Cheers Kris - that's really handy

Paul