Microsoft's recommendation is that you don't have trustworthy destinations on your community as destinations exterior your computer are significantly less Risk-free. The default environment reflects this. In addition, Based on Microsoft, it is best to stay clear of including general public folders on network shares as trusted areas. “SECURITY Hazard https://www.customguide.com/google-sheets/conditional-formatting-google-sheets