conditional format columns

[Cerberus]

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.

 

[Jacob Skaria]

Select the column range and type in the formula referring to the 1st cell
If the first cell is G2 in the selection; type
Format>Conditional Formatting>Cell Value is>equal to
=X2

Excel assigns the formula automatically to other cells...

If this post helps click Yes