Martin_H
Board Regular
- Joined
- Aug 26, 2020
- Messages
- 190
- Office Version
- 365
- Platform
- Windows
Hi team,
as the title says, I have a workbook that contains 5 sheets with multiple Conditional Formatting.
Whenever I chose anything from drop-down list (data validation list) Excel kinda slows right after for about half a second.
I am using Conditional Formatting to color rows based on the specific cell value.
Each sheet contains around 100 rows (so 5 of them = 500 rows).
Is there anything I can do to avoid getting those half-second freezes after each drop-down selection other than deleting conditional formatting?
Thanks a lot.
Much appreciated.
as the title says, I have a workbook that contains 5 sheets with multiple Conditional Formatting.
Whenever I chose anything from drop-down list (data validation list) Excel kinda slows right after for about half a second.
I am using Conditional Formatting to color rows based on the specific cell value.
Each sheet contains around 100 rows (so 5 of them = 500 rows).
Is there anything I can do to avoid getting those half-second freezes after each drop-down selection other than deleting conditional formatting?
Thanks a lot.
Much appreciated.