Dynamic Conditional Formatting: How to Link Rules to Specific Cells
If you want to create conditional formatting rules but want to easily change the cutoff values for them, you can link your rules to specific cells, to make that process easy. Below, I'll show you how to make your conditional formatting rules dynamic ...