conditional format columns
 

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.

conditional format columns
 

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.