Formatting Linked Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a project to do. I have to create an input worksheet that is the originator of other worksheets that are linked to the input worksheet. Is there a way to have the linked cells shown as a blank cell if the data (especially text data) is not enter in the input worksheet yet.

MT
 
Hi

=IF(YourLink="","",YourLink)

--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


MT said:
I have a project to do. I have to create an input worksheet that is the
Click to expand...
originator of other worksheets that are linked to the input worksheet. Is
there a way to have the linked cells shown as a blank cell if the data
(especially text data) is not enter in the input worksheet yet.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Tweaking VBA 1
cells linked from worksheet to worksheet 1
Lock format but allow data entry 1
Linking Cells from a different Worksheet with an IF Function 2
Cells act as if they are linked-link does not display in entry bar 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
autocalculate doesn't work even with formula . 1

Back
Top