I have a table (45 rows x 109 columns). One column is named "Task", the task column has Data Validation that allows the user to pick from 39 different tasks.
I have conditional formatting for each of the 39 tasks that applies a "Fill Effect" to each cell in the row based on the task that is selected.
This is causing the spreadsheet to have a noticeable delay when any information (the information being entered are just numbers) is entered into one of the cells
Is there anything that could be done or is this just an issue with conditional formatting?
Here is a screenshot of some of the conditional formatting rules I have setup
I have conditional formatting for each of the 39 tasks that applies a "Fill Effect" to each cell in the row based on the task that is selected.
This is causing the spreadsheet to have a noticeable delay when any information (the information being entered are just numbers) is entered into one of the cells
Is there anything that could be done or is this just an issue with conditional formatting?
Here is a screenshot of some of the conditional formatting rules I have setup