Hi Guy & Girls,

Have a current situation with an alarms list from DCS system at work output file is .CSV.

Each alarm has specific tag and all have priority ratings

What I would like is a template type WorkSheet with possibly some code/VBA where by when the alarms list in copied and pasted from DCS to excel file all high priority alarms are flagged i.e. cell turns red or something to that effect

Dont have much knowledge of VBA but would appreciate push in the right direction. Using Excel 2007 also

Thanks for your help in advance.