Conditional formatting to highlight a cell if a certain value appears in another sheet
I am needing to add shading to a cell to highlight if a figure appears in another tab:
For example, highlight column B, next to 1.1.1, if 1.1.1 appears in any of the cells in columns B-H on the ‘Sample’ sheet:
I will then replicate this for multiple sheets, and multiple columns on the ‘Coverage tab’, can anyone help please?
I am needing to add shading to a cell to highlight if a figure appears in another tab: For example, highlight column B, next to 1.1.1, if 1.1.1 appears in any of the cells in columns B-H on the ‘Sample’ sheet: I will then replicate this for multiple sheets, and multiple columns on the ‘Coverage tab’, can anyone help please? Read More
