Conditional formatting rules less than Average line, and utilize that rule across all columns.

Copper Contributor
Months in DateRevenueTotal Visit CountRev Per PatientActive Caseload
01/202315113149137411
02/202319300191175511
03/202322299229171513
04/202314902149135511
05/202320075201200810
06/202325646247160316
07/202321331218152414
08/202322851227190412
09/202317876182149012
AVERAGES19933199163612

 

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. 

1 Reply

@Renard23 

=B2<B$11

This is the rule for conditional formatting in the example.

=$B$2:$E$10

This is the range the conditional format applies to.

conditional format.png