hi, what happen is the project didn't include vba only using excel to show the record in the pivot table. so that's is the problem i'm facing. what i thought is i may use the formula statement in the conditional formatting. so i still looking the solution, thank