Forum Discussion
Conditional formatting rules less than Average line, and utilize that rule across all columns.
| Months in Date | Revenue | Total Visit Count | Rev Per Patient | Active Caseload |
| 01/2023 | 15113 | 149 | 1374 | 11 |
| 02/2023 | 19300 | 191 | 1755 | 11 |
| 03/2023 | 22299 | 229 | 1715 | 13 |
| 04/2023 | 14902 | 149 | 1355 | 11 |
| 05/2023 | 20075 | 201 | 2008 | 10 |
| 06/2023 | 25646 | 247 | 1603 | 16 |
| 07/2023 | 21331 | 218 | 1524 | 14 |
| 08/2023 | 22851 | 227 | 1904 | 12 |
| 09/2023 | 17876 | 182 | 1490 | 12 |
| AVERAGES | 19933 | 199 | 1636 | 12 |
Hi I'm trying to highlight all the cells in one column that are below the average. Then I want to slide it across to provide the same conditional formatting rule to highlight all the cells that are Below the average for each specific column.
=B2<B$11This is the rule for conditional formatting in the example.
=$B$2:$E$10This is the range the conditional format applies to.
