Conditional formatting formula - multi criteria please

[Orangeanorak]

conditional formatting?

I posted something similar to this some time ago but never got an answer and it 'fell off' the board. Here's hoping for a solution this time please.

1. Formula please to highlight the cell in column H that is equal to or nearest to J1 IF the cell in the same row in column J equals 7


2. Formula to highlight the cell in column B if the cell on the same row in column H is highlighted as a result of the above.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	*	*	*	*	*	*	*	*	*	17
2	*	*	*	*	*	*	*	*	*	*
3	*	*	*	*	*	*	*	*	*	*
4	1	Red	*	*	*	*	*	7	*	7
5	2	Black	*	*	*	*	*	8	*	7
6	3	Blue	*	*	*	*	*	17	*	3
7	4	Green	*	*	*	*	*	8	*	7
8	5	White	*	*	*	*	*	49	*	6
9	6	Brown	*	*	*	*	*	5	*	2
10	7	Grey	*	*	*	*	*	31	*	5
11	8	Scarlet	*	*	*	*	*	11	*	6
12	9	Yellow	*	*	*	*	*	13	*	5
13	10	Orange	*	*	*	*	*	22	*	1
Sheet

Thank you - your help is appreciated

 

[Orangeanorak]

Thank you Peter SS I shall use your solution and heed your advice on posting quotes. i was not sure you were available to come back on this and posted the quote to facilitate others who had come onto this thread for first time.

thanks again