Highlight Row Where Cell Value is same as Cell Value from another Worksheet
Posted on 2011-03-16
Two sheets Master Census and Canceled Contracts
If the exact patient name is entered into the Patient Name column on the Canceled Contracts sheet I want the entire row of the same Patient Name to turn red on the Master Census sheet.
I got the cell to change using the Match Function but I want the entire row to change to red fill.