Select the column range and type in the formula referring to the 1st cell
If the first cell is G2 in the selection; type
FormatConditional FormattingCell Value isequal to
=X2

Excel assigns the formula automatically to other cells...

If this post helps click Yes
---------------
Jacob Skaria


"Cerberus" wrote:

I am trying to set a conditional format to 3 different columns. The issue
I'm having is, I need to have a formula that says something like if G2 = X2
then fill it yellow. G3 = X3 fill yellow, G4 = X4 fill yellow and so on. I
normally wouldn't mind setting it up manually for each cell but there is 2066
rows and 3 different columns to conditionally format.

Thanks for any tips in advance.