Column E2:E10000 require individual conditional formatting if there is a particular value in the same row but in column AD.
If AD2 is equal to "NOK", apply conditional formatting to E2.
If I copy this format to the 10000th row, E10000 is still focused on AD2.
I understand about the $ sign, but can't change the automatic entry into the "Applies to" box of the conditional formatting rule manager. As soon as I click on the apply button of the conditional formatting rule manager, the $ signs come back.
I hope somebody can help.
Thanks in advance.
Kev
Bookmarks