Conditional formatting - maybe

[Kade]

Col A is a list of random numbers

Col B at irregular intervals will have a "sum" formula adding a number of cells in col A (may not be consecutive)

Can the cells referenced in the sum formula )col A) become highlighted (either cell colour or text colour) when I select the relevant cell in Col B

Book2
	A	B	C	D	E	F
1
2	65	246
3	89
4	87
5	5	114
6	22
7	66
8	55
9	44	255
10	88
11	65
12	3
13	2
14	5
15	998	1594
16	36
17	56
18	7
19	6
20	1	115
21	9
22	1
23	881
24	6
25	5
Sheet1

 

[Juan Pablo González]

Well, one easy solution would be to press F2 when you select the "appropiate" cell in column B. Try it, it's a very cool thing to use