Forum Discussion
Solved
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...
Sheet names that contain spaces or punctuation must be enclosed in single quotes:
=COUNTIF('Paper 1'!$B:$H, A3)You can also do the following:
In B3:
=COUNTIF(INDIRECT('"&B$2&"'!$B:$H"), $A3)This can be filled or copied down and to the right.
Thank you so much, how would I replicate for other sheets? eg the same thing for for multiple tabs and multiple columns?
I tried copying the formula and replacing 'Sample' with 'Paper 1' but it came up with an error message so assuming I did something wrong!
Sheet names that contain spaces or punctuation must be enclosed in single quotes:
=COUNTIF('Paper 1'!$B:$H, A3)You can also do the following:
In B3:
=COUNTIF(INDIRECT('"&B$2&"'!$B:$H"), $A3)This can be filled or copied down and to the right.
- thank you so much, got it all working across all of the sheets now!