VBA code or Macro to Latch or Hold, maybe via a ‘Helper Column’

[dublindub]

Spent the last 3 days attempting to find a VBA code or macro for the following:

Have a Spreadsheet set up to use the Betfair IPA data to automatically ‘Back to Lay’ horse racing, it works fine and puts the Back and Lay bets on at the appropriate times, I then have Conditional Formatting set up to record between 2 column when the appropriate row cells have matched (i.e. hit the 50% odds required).

Problem is this hit is only momentary and I am looking for a VBA code or Macro to Latch or Hold, maybe via a ‘Helper Column’ when this matches so I can view this at any time.

Much appreciated in advance if anyone can advise on this.

[vbfbryce]

Are you saying you want to retain the history of the matches somewhere, or am I misunderstanding you?