I'd like to have the highest and lowest values in a row be a different colour than the rest of the cells. This is a simple conditional formatting issue when there is only one line. The problem is I want to do it for many rows but if I select all the rows to make the rule it only gives the highest and lowest of the whole selection. Is there a way to copy a rule, or create a rule shortcut so I can apply the rule to each row?

Thanks