Enter some text if a cell is not blank

[seansr]

I want to enter some text if a cell is not blank

I have a massive spread sheet and there are certain fields I must fill in, so for those that have to be filled in I already use something like this..=IF($AT120="Yes","**????**", " ")

I want to enter **?** in the relevant fields lets say cell z100 if A100 has something in it.

I already use conditional formatting so that any cells with **?** show in bold and Purple so they stick out

So if A1 is Blank ignore otherwise enter "**?**"

Can you assist me

 

[Gary's Student]

In cell Z100, enter the formula:

=IF(A100<>"","**?**","")

 

[seansr]

In cell Z100, enter the formula:
=IF(A100<>"","**?**","")

Perfect Thanks much appriciated