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!!
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!!