Microsoft Office Forums - View Single Post - How Can I Flag Duplicate Date Entries?

Thread: How Can I Flag Duplicate Date Entries?

View Single Post

Old

11-14-2012, 11:22 AM

Kevin@Radstock Kevin@Radstock is offline

Kevin@Radstock is offline

Kevin@Radstock uses Windows 7 32bit

Windows 7 32bit Kevin@Radstock uses Office 2010 32bit

Kevin@Radstock uses Office 2010 32bit

Office 2010 32bit

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Default

Hi tatihulot

I am not a great lover of the built in Conditional Formatting. But here you go, nice and simple. Select the range you wish to conditionally format. Home tab > Styles > Conditional formatting > Highlight cell rules > Duplicate values > Format as required.

Reply With Quote