Tech Xpress

Highlight Duplicate Cells in Excel

Finding duplicate values in an Excel spreadsheet can often be painfully boring. But if you know how to do it, its actually quite easy. Here's the way to easily get it done.

How to Highlight Duplicate Cells in Excel 2007 and Excel 2010

1. Select the cells for which you want to find and highlight duplicate values.


2. In the Home tab, go to Conditional Formatting >> Highlight Cells Rules >> Duplicate Values...


3. The Duplicate values box appears. Select the color to apply for duplicate cells. Click Ok.



4. Bingo! The duplicates are now highlighted.

More Tips:
Freeze First Column and Row in Excel
Convert Rows-to-Columns and Columns-to-Rows in Excel

posted by Vijeesh Ravindran, Saturday, October 29, 2011
| link | 0 Comments |

Magazine is Broken iPad to One-Year-Old Baby

Here's a nice video of a one-year-old toddler who understands the touchscreen of an iPad, but gets confused when she tries to pinch and swipe a magazine and nothing happens.


This video was posted by Jean-Louis Costanza. And I found it on Techmeme.

posted by Vijeesh Ravindran, Sunday, October 16, 2011
| link | 0 Comments |