I wish to format cell if it was pasted with link to another sheet. How to define if cell is linked?

I go to Format » Conditional Formatting. Condition 1 is Formula. =IF(... and I'm stuck =)

  • You can check if it's a link (reference), by using the formula =ISREF(<current cell address>), replacing <current cell address> with the address of the cell. – tohuwawohu Feb 7 '17 at 17:44

For example, start with this, where sheets are named "Sheet1" and "Sheet2":


Then in conditional formatting, choose Formula is. Use SEARCH and FORMULA:


conditional formatting dialog

Giving this result:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.