Conditional formatting to highlight a cell if a certain value appears in another sheet

[JoeWilson5]

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?

[#2]

@JoeWilson5

Select B3:B27. B3 should be the active cell in the selection.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula

=COUNTIF(Sample!$B:$H, A3)

Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.