Within a workbook I have one worksheet ('Attendance') containing cells with comments where the fill tool has also been used to indicate the comment category (the cells are yellow for uncertain, as shown below, green for certain, red for uncertain etc).
'Attendance' sheet showing example of comment:
I have another sheet ('Comments') which lists any cells with comments from 'Attendance' (IE the active sheet) and also a cell reference in column B referring to the cell in which the comment appears. This was generated using a Macro I found on here.
'Comments' sheet showing columns for sheet name, cell reference, cell value, comment, respectively
What I'd like to do is to run a macro that copies the cell colour of the cell in 'Attendance' referenced in column B of 'Comments'. I'd also like to know how to apply this to the whole of column B of 'Comments', as shown in the attached image below
'Comments' showing intended effect of colouration based on cell reference in other sheet
Any help would be greatly appreciated as I couldn't find another thread that encapsulated the question of copying cell colour based on cell reference in another sheet. I think a solution might be based on using Indirect but I'm not sure about since I'm new to VBA.