Highlight highest value in every column

[gordsky]

I have a spreadsheet with around 50 columns of data. What I want to achieve is that the highest value in each column is highlighted.
I have managed to do this for a single column using conditional formatting and the formula

=c7=max($C$7:$C$60)

Is there a way to adapt that formula so that it will work in every column rather than having to create a new conditional format for each column.

 

[Alex Blakenburg]

Did you try removing the column $ sign ?
=c7=max(C$7:C$60)

 

[Muhammad_Usman]

> Select your all 50 column .
> then Apply same formula just change $ Sign
=c7=max(C$7:C$60)

This will work for you

 

[gordsky]

thank you both for your help and yes that is exactly what i was trying to do but couldn't for the life of me get it to work.
Alex I have shown yours as the solution as your reply is timed first but muhammad I have given you a like.
thanks again

 

[Alex Blakenburg]

Thanks for the feedback, glad we could help.