Conditional formatting - Highlighting a row
=NOT(EXACT($A1,$B1))
"Coco" wrote:
How do I tell Excel to highlight the entire row when data from two columns
does not match exactly, i.e. g3 should be exactly the same as h3 but if not,
highlight the entire 3rd row?
Thank you.
|