Conditional formatting

Each month I keep a list of receipts for purchases made.

Column A contains a brief description of the item, Column B contains the date, Column C contains the cost.

In April 2014 (for example) I have used entry A8 to contain conditional formatting so that any following identical name entry will also be highlighted in a green background with black text.

The problem is how to replicate this to all the other identical word entries (May to October) without a laborious copy and paste method?

Please let me know if you require a spreadsheet sample.

Thank you.

David in HK

Hi,

not sure to have understood.

If you apply in A8 a format rule

Formula:

Please Login or Register  to view this content.

and you extend the rule to A8:A1000 it should do the trick.

Hope it helps

Hi, thanks for providing feedback.

Regards