Trying to Reference Cells One to One in Conditional Formatting

[cdfeatherstone7]

Hi,

I'm using conditional formatting where one column of cells is referencing another column of cells. For example, I want cell K2 to highlight if the date entered doesn't match the date in F2. I then want cell K3 to highlight if the date entered doesn't match the date in F3. I want cell K4 to highlight if the date entered doesn't match the date in F4 and so on. I'm not having any issue putting conditional formatting on the cells/row references individually, but when I try to copy the formatting (by using format painter) to save time all of the cells in column K just reference the first cell in column F since the first cell in column K references that F cell but not any other F cell. How do I copy these row by row references between columns so that each reference is unique?

Thanks!

[cbatrody]

Hi,

Please change the formula in conditional formatting window as following by keeping the cursor in K2


=K2<>F2

change the formatting as desired.

Now you can drag down using Format Painter.