Conditional Formatting - comparing text in two cells

[aitzko]

Hi everyone,

I'd like to highlight a row if the text in two cells does not match. For example, if cell D4 = "DC" and cell E4 = "DC", I'd like it to remain with no color. If cell D5 = "DC" and cell E5 = "CA," I'd like all of Row 5 to be highlighted. Can anyone help with this?

I'd like to apply this conditional formatting to the entire worksheet.

Thanks!!

 

[texasalynn]

try the formula is
=D4<>E4

 

[aitzko]

Hi Texasalynn,

Thanks for your reply. For some reason, this highlighted all of column B, and seemingly random cells in column A. Any idea what's going on? I"ve never used a formula like that before.

Thanks!

 

[aitzko]

Hi Texasalynn,

Thanks for your reply. For some reason, this highlighted all of column B, and seemingly random cells in column A. Any idea what's going on? I"ve never used a formula like that before.

Thanks!

 

[texasalynn]

oops need to anchor the columns

=$D4<>$E4

 

[aitzko]

Perfect!!! Thanks a million!!!