HELP: Need a quicker way to compare a range of columns using conditional formatting

Originally Posted by LJMetzger

Hi nez329

You can cut and paste the FORMATS.

Select a range of cells having the proper conditional format (e.g. B3:B12)
Press CTRL-C to copy
Select the first cell in the destination range (e.g. D3)
Edit > Paste Special > Formats > OK

Lewis

Oh, forgot to add that some of the data is strikethrough. So that will not be possible.