conditional formatting

[dan]

Can I conditional format a cell with color if the cell has a formula?
If yes, please advise.

 

[Allllen]

Dan,

Yes, that is what it is for
Read more here http://www.contextures.com/xlCondFormat01.html

 

[dan]

Hi, Allen
I meant that if cell G2 has a formula i.e. Formula is =HASFORMULA(G2)
simular to Formula is =ISERROR(C2)
Thanks