H
I have a row with 5 numbers in it and I want the highest number to be displayed in blue.
I am using conditional formating as follows:
Cell value is ---- greater than or equal to---- for each of these cells.
Cell 1 =MAX(AJ:AN)
Cell 2 =MAX($AI$3,$AK$3,$AL$3,$AM$3,$AN$3)
Cell 3 =MAX($AI$3,$AJ$3,$AL$3,$AM$3,$AN$3)
Cell 4 =MAX($AI$3,$AJ$3,$AK$3,$AM$3,$AN$3)
Cell 5 =MAX($AI$3,$AJ$3,$AK$3,$AL$3,$AN$3)
Cell 6 =MAX($AI$3:$AM$3)
It all works fine, but when I copy down, the formulas stay relative to row 3 (ie $AI$3)
I have tried copying the normal way and have tried the format painter.
Does anyone know the solution or another way to do this as I have about 500 lines to copy down and I dont fancy doing it all by hand!
Cheers
Simon
I have a row with 5 numbers in it and I want the highest number to be displayed in blue.
I am using conditional formating as follows:
Cell value is ---- greater than or equal to---- for each of these cells.
Cell 1 =MAX(AJ:AN)
Cell 2 =MAX($AI$3,$AK$3,$AL$3,$AM$3,$AN$3)
Cell 3 =MAX($AI$3,$AJ$3,$AL$3,$AM$3,$AN$3)
Cell 4 =MAX($AI$3,$AJ$3,$AK$3,$AM$3,$AN$3)
Cell 5 =MAX($AI$3,$AJ$3,$AK$3,$AL$3,$AN$3)
Cell 6 =MAX($AI$3:$AM$3)
It all works fine, but when I copy down, the formulas stay relative to row 3 (ie $AI$3)
I have tried copying the normal way and have tried the format painter.
Does anyone know the solution or another way to do this as I have about 500 lines to copy down and I dont fancy doing it all by hand!
Cheers
Simon