MAX function and formatting

[bridget_]

I have a spreadsheet that has 80 measures as rows and about 220 measures in the columns. The rows are listed alphabetically, and the cells are highlighted based on certain percentage ranges (for example - in column C, row 35 the percentage is red because it falls below a minimum standard). I am using the max function to figure out the highest percentage in each column, however I can not figure out how to carry over the formatting of the cell with the highest percentage.....HELP!

[etaf]

can we see a sample spreadsheet - with dummy data - this is a public forum
not sure I understand the

however I can not figure out how to carry over the formatting of the cell with the highest percentage.....HELP!

is this to conditional format the entire row ?

[FDibbins]

Hi and welcome to the forum

short version...you cannot "carry over" formatting from 1 cell to another (without using VBA) However, if there is some logic behind wht a particular cell has a certain format, then that same locig may be able to be used to Conditional Format another cell