One way:

=IF(Sheet1!A1<"","X","")

In article ,
"Task Lead Nicole" <Task Lead wrote:

Is there a way to create a macro or formula or a cell format to populate a
cell that is getting info (external data) from a link to a cell in another
worksheet so that it just inserts an "X" or something like that IF the source
cell is NOT NULL (or not empty)?