0

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

 

Download the file to practise on 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.

 

 

Continue Reading

0

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. 

Continue Reading

0

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.

 

 

Download the file to practise on here. 

 

 

 

 

Continue Reading