Excel: Conditional Formatting

While using Excel to gather business requirements we often have repeated cells of data. To make things easier to scan and read we can use conditional formatting to change the look of repeated cells.

For example, the following data would be hard to read when there are hundreds of columns and thousands of rows:

Whereas the following data is much easier to scan and read:

To create this effect, in Conditional Formatting create a formatting rule where
Format values where this formula is true:
=(A2=A1)

Text Format:
Font Color = Grey