If a certain cell entry is found in column C of the other eleven sheets, then colour the entry in red. Furthermore, a summary sheet should show all red coloured entries.
You may refer to my solution in this workbook.
If a certain cell entry is found in column C of the other eleven sheets, then colour the entry in red. Furthermore, a summary sheet should show all red coloured entries.
You may refer to my solution in this workbook.
Lookup for a cell value in multiple sheets
{ 0 Comments }