Conditional Formatting

[Jim]

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

 

[Jonathan Cooper]

=if(A6<>"",1,0)

 

[B. R.Ramachandran]

Hi Jim,

=NOT(ISBLANK(F6))

Regards,
B. R. Ramachandran

 

[B. R.Ramachandran]

Hi Jim,

Sorry for the typo. I meant
=NOT(ISBLANK(A6))

B. R. Ramachandran

 

[David Biddulph]

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