Forum Discussion

Lachlan1530's avatar
Lachlan1530
Copper Contributor
May 18, 2023
Solved

Is there a way to set a static range for conditional formats on Excel for Web?

As the question states, I have a fair amount of conditional formatting available in a workbook and I want to set the range the conditional formats apply to so that the only way to change that range i...
excel
Excel for web
  • NikolinoDE's avatar
    NikolinoDE
    May 18, 2023

    Lachlan1530 

    As far as I'm aware, Excel for the web doesn't provide a built-in feature to set a static range for conditional formats. If you move or change data within the range, the range will automatically adjust to the conditional formatting rules.

     

    One possible workaround you can try is to use a VBA (Visual Basic for Applications) macro to apply and maintain the conditional formatting with a static range. However, please note that VBA macros are not supported in Excel for Web. They can only be used in the desktop version of Excel.

     

    If you need to maintain a static range for conditional formatting in Excel for Web, you may consider using the desktop version of Excel. The desktop version offers more advanced features and customization options compared to the web version.

Resources