Microsoft Office Forums - View Single Post - [Solved] Finding Duplicates & Unique Values in More Than One Sheet

Thread: [Solved] Finding Duplicates & Unique Values in More Than One Sheet

View Single Post

Old

03-07-2020, 11:13 AM

Marcia

Marcia is offline

Marcia uses Windows 7 32bit

Windows 7 32bit Marcia uses Office 2013

Marcia uses Office 2013

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 527

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Default

Click conditional formatting>manage rules>in the apply to, change F2 to F15. Or, select A2:F15, then repeat the conditional formatting process.

Reply With Quote