Hi,
I use a worksheet with data in it and I want to use conditional formatting to highlight a cell if there is data in another worksheet within the same workbook.
So, for example, Sheet A, column c is fully populated down to row 500. If I enter text in Sheet B, cell B1 I want Sheet A, cell C1 to have shading applied.
I know this is possible as I did have it but someone deleted it from my sheet.
Thanks in advance
I use a worksheet with data in it and I want to use conditional formatting to highlight a cell if there is data in another worksheet within the same workbook.
So, for example, Sheet A, column c is fully populated down to row 500. If I enter text in Sheet B, cell B1 I want Sheet A, cell C1 to have shading applied.
I know this is possible as I did have it but someone deleted it from my sheet.
Thanks in advance