Adding Border to an Entire Row if a Value in 1 cell is unique???

[rcravatts]

Hello!

This is my first post on ExcelForum!

I have been trying to use conditional formatting to Add a Thick border to an entire row within a table based on 1 Cells Value being the first unique number. I have a table with 700 rows and in Column C there are numbers ranging from 1-380. For each number there is a random number of occurrences, for my purposes I need to format the table to be easier to read, so I have sorted from 1-380, and now want to add a dark border to one edge each entire row, each time the number in Column C is the first occurrences of that number. I also was think another approach would be to have a formula where if c2>c1, then format. Any thoughts on this??

I have the general ideas down as to how to get this done, but have not been successful in actually getting the entire row formatted in the desired way.

I have excel 2010. Thanks!!!

[Pauleyb]

Your title says you are looking for unique values. Your text says you are looking for any time the number in column C changes. Those are two different equations.

Since the bulk of your text is around a sorted list and wanting to highlight a change, it seems you are in the right direction. There are two 'gotchas' on this one.
1) You are formatting a cell, so the border would be applied at the cell level and not at the row level. In other words, the entire row would have a border around each cell on that row. Probably not what you are looking for. A color change may look more consistent.

2) You only want the conditional format to care about what is in column C, so your equation will need to be $C2>$C1. Note the $ signs. Then your Applies To range would be something like =$1:$380