highlight cell based on coordinates in another sheet

[jnwilson]

Hello,

in my workbook i have 3 sheets, 2 contain data (Sheet 1 and Sheet 2) and another references specific cells on those 2 data sheets.

the reference sheet looks like this

is there a way (prefereably without VBA) that i can highlight the cells in the data sheets (sheet 1 and 2) that are specified here in the reference sheet?
I need it to be dynamic too, as the sheets and cells will change each time i run this report.

Thank you in advance.

 

[Eric W]

You could set up a Conditional Formatting rule like this:

Book1
	A	B	C	D
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:R30	Expression	=COUNTIFS(Sheet3!$A$2:$A$100,"Sheet1",Sheet3!$B$2:$B$100,ADDRESS(ROW(),COLUMN(),4))	text	NO

Select the total range that might be highlighted, then apply the formula as shown. Sheet2 would have a similar rule.

I notice that you have the filtering symbol on your display. Do you only want to highlight the filtered rows? If so that would be trickier.

 

[jnwilson]

No, I was filtering just for the screenshot. This works great!! thank you so much

 

[Eric W]

Happy to help! Thanks for the follow-up. ?