excel - Conditional Formatting based on relative column

Question

I have a sheet in which I created a conditional formatting rule:

if columnB > 50 then columnA fill color green.

The result is OK for the whole of columnA, based on columnB. The problem is that when I copy the format to columnX this should be based on columnY but remains based on columnB.

I need an automatic way to format the cells based on the neighbouring column and not a fixed column.

Answer 1

Take the anchor ($) off the front of your B in the formula for the formatting being copied before copying.