## FIND DUPLICATES IN EXCEL | PART ONE

Published on September 25, 2012 by in Excel | Conditional Formatting, Excel | General, Excel | Useful tricks

In this post, I’m going to show you how to locate duplicates in Excel. I’m going to look at two scenarios. In the first scenario – we just have to identify duplicate/unique values in a list. For this I’m going to use Conditional Formatting . I also show you how to copy conditional formatting using the Format Painter

The steps are as follows:

1. Highlight the area you want to apply conditional formatting to (don’t forget to use Ctrl and Shift and Arrow Down to quickly highlight – and if you haven’t done so already – you can get lots of other shortcuts in the sheet you get when you sign up )
2. Home – Conditional Formatting – Highlight Cells Rules – Duplicate Values
3. Choose whether you want duplicate or unique values – and then choose your formatting
4. You can copy the formatting using Format Painter or
5. Remove the Formatting by using Conditional Formatting – Clear Rules

View the video here

You can view Part Two of this blog post where I show you how to use conditional formatting to  highlight the entire  row  where a room has been double-booked.

## EXCEL CONDITIONAL FORMATTING WITH FORMULA

Published on August 20, 2012 by in Excel | Conditional Formatting, Excel | Intermediate Lessons

In a previous post, I showed you how to use conditional formatting in Excel to highlight entire rows based on a specified criteria. In this post, I am going to show you how to use the AND function to conditionally format rows based on multiple criteria.

As always, there is a file for you to practise on.

## CONDITIONAL FORMATTING BY ROW

Published on August 20, 2012 by in Excel | Conditional Formatting

In this video, I am going to show you how to use conditional formatting to highlight an entire row based on a single criteria (rather than just highlighting the single cell).  In another post, I am going to show you how to use the And function with conditional formatting to specify formatting based on the meeting of two criteria.