conditional format columns

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.
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top