Predecessors #ref formula

Cameron Yule

I am building a template which requires users to delete un-required task rows. This then creates #REF in the predecessors box (along with the other predecessors)

I would like to highlight the predecessor box containing #REF but i cant get a formula to identify the data

Aravind GP

Hi Cameron,

Since you just want to highlight, you can set up a Conditional Format as below to quickly see all rows that have this error.