hi, I try to use "AND" formula in conditional formatting to highlight B2="USD" when C2=EMPLOYEE. but i not highlighted correctly. please help. Thanks, ^_^