conditional formatting
 

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

conditional formatting
 

Dan,

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

--
Allllen


"dan" wrote:

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

conditional formatting
 

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

"Allllen" wrote in message
...
Dan,

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

--
Allllen


"dan" wrote:

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