I need to copy conditional formating down a column.
The values are based on VLOOKUP formulas.
When I compare J2 to F2, everything works.
When I copy the Formatting down the column, every cell is compared to F2.
I have tried dollar signs but to no avail.
Can someone help please?