Good morning all... hoping that someone can give me a formula / VBA that will identify lines that contain color highlighting please?
I have a workbook containing approx 50 worksheets, each containing between 4 and 200 lines and I am trying to consolidated data onto the first workbook based on rows that have had some lines highlighted cells within. Highlighted cells are all yellow.
I am all set to consolidate the data but need a function to identify which lines are highlighted yellow.
Thanks in advance
I have a workbook containing approx 50 worksheets, each containing between 4 and 200 lines and I am trying to consolidated data onto the first workbook based on rows that have had some lines highlighted cells within. Highlighted cells are all yellow.
I am all set to consolidate the data but need a function to identify which lines are highlighted yellow.
Thanks in advance