You don't need the IF(...,1,0)
=A6<"" will do.
--
David Biddulph

"Jonathan Cooper" wrote in
message ...
=if(A6<"",1,0)



"Jim" wrote:

Hello,

I did search this question but could not find an answer.

If I want to format f6 only when there is data in a a6: what formula do I
enter?

Thank you