I'm hoping someone can help me with this. I want to have a row highlighted yellow in columns A:T if the patient name in column I and MRAdmit number in column H appear on the prior period unbilled tab
the prior period unbilled tab has data in columns A:AF and the patient name appears in column E while the MRAdmit number appears in column A
the prior period unbilled tab has data in columns A:AF and the patient name appears in column E while the MRAdmit number appears in column A