List of Codes on one sheet, Billing data on another sheet, highlight code if in list

[children]

List of Procedure Codes on one sheet, Billing data on another sheet, highlight procedure code on billing data sheet if it is on the list sheet

[Tony Valko]

Can you be more specific as to where this data is located?

[mlcb]

Name the range, on the first sheet, containing the codes, say, ProcCodes

Assuming that the Procedure Codes in the second sheet are in column A, i.e., A2:An (adjust to suit)
Select A2:An

Home > Conditional Formatting > New Rule > Use a formula to determine which cell to format

enter this formula
=COUNTIF(ProcCodes,A2)
pick the format you want
Ok, Ok

[children]

thanks mlcb that did it

[mlcb]

thanks mlcb that did it

You are welcome. Glad for helping

M.