, Good afternoon.
Are you talking about rows or columns?
It looks like you want Column A to have rules based on cell at row 2.
And you then want to copy this format to other columns, type: B, C, D, up to ET.
Just remove the $
sign from the column in the formula.
Before: cell value>$A$2 = red
Now...: cell value>A$2
Please, tell us if it worked as you desire.
I hope it helps.
Belo Horizonte, Brasil