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
Bookmarks