conditional format columns

  • Thread starter Thread starter Cerberus
  • Start date Start date
C

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.
 
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
 
Back
Top