Hi there,

Sorry if this has been asked previously but I have done a lot of searching online and not been able to find a suitable solution. I have had no excel training and a very basic user and would really appreciate your help!

I am trying to automate a very tedious task.

Basically I need Excel to find the first cell of a specific colour that is not in the index but it have the hex code and RGB value (32CD32 & 50,205,50) and once it has found it to return the column header.

In the attached picture (using row 3 as an example) I would like to be able to put a formula/macro into C3 to identify the first cell with the specific colour (D3) colour in each row and return the value in D1.

Sorry if this is not specific enough i'm happy to answer any questions.

Thanks,

John