To use the IQR method, calculate the first quartile (Q1), third quartile (Q3), and IQR of your data using Excel’s QUARTILE.EXC function. Define outlier boundaries as Q1 – 1.5*IQR for the lower bound and Q3 + 1.5*IQR for the upper bound. Use conditional formatting to highlight values outside these boundaries.