Excel Document

Hello Teresa,

Thank you for your question and for sending the data file. To update the drop-down lists, you need to go to Data - Data Validation. To see which cells contain data validation rules, go to Home - Find and Select, Data Validation.

I notice that there are certain cells where the validation lists are manually typed into the Data Validation box. You can update these in this box.

Other cells contain lists which are in a hidden sheet named Data. You will need to unhide this sheet and update the lists here. The Data Validation box shows you which ranges contain the lists.

To apply red conditional formatting to text cells, you need to select the cells, then go to Home - Conditional Formatting - Highlight Cell Rules - Text that contains. Here you type the text which should appear in the cells and select a red colour.

Regarding the slow opening of the file, it seems that Excel is struggling to connect and update the links to four external files. It might be worth checking these files and the health of the links. You can see the links in Data - Edit Links.

I hope this helps.

Kind regards
Marius Barnard
STL