How can I keep conditional formatting in a template spreadsheet? It's set up and works until I save it as a template, then the formatting is lost.

Does anyone know if it is common for conditional formatting to be lost on a spreadsheet when it's saved as a template? I'm not sure if this is a normal issue or if it's because I'm working in an organisation that shares documents across two SharePoints, so it might be losing something in the saving process. That does seem odd though!

Essentially I've set up a sheet that should change the colour of a whole row depending on whether it is marked as pending, complete or cancelled. In the sheet I've set the rules up in it works, but as soon as I save it as a template and open it from that file type the formatting is lost.

(ETA: Using Excel on desktop through Office 365 Apps for business, am an intermediate excel user, don't need help with the formula unless that impacts what stays in an excel template)