Is it possible to have specific background colours (the entire row of the file) for specific file types automatically when opening a specific folder?
Yes. Define a label...
... and assign it to the file type/path: