I have two columns of data.

I want to programmatically create conditional formatting on the second
column where the color of the cell is based on the value of the cell to its
left. This would apply to the whole range of the second column.

I can see how to do this if I was basing the formatting on the same cell as
the formatting is to be applied to.

What is the syntax in the macro to do the formatting based on the value of
the cells in the first column?

Thanks in advance for any help you can offer!

Steve