Conditional Formating - Column and Row Highlighting

[Tim Ball]

I have a query relating to conditional highlighting - specifically highlighting a cell's column and row based upon whether it contains data or not i.e. if it is blank, it's column and row remain unhighlighted, but when it contains data, it's column and row should become highlighted. I could probably manage this myself but I have a few more specific requirements which I have illustrated with a few screenshots, however I can't see how to make these available to view here!IOII

 

[Tim Ball]

Apologies, I've just read the 'Forum Posting Guidelines'! I'm operating MS Excel 2010 on Windows 7. I have attempted to use MrExcel HTML maker and have attempted to paste the code below.

---

Excel 2010

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Job No:			Sheet No:
2	1234			0a
3	PROJECT:																			DOCUMENT REGISTER / ISSUE SHEET
4	Project Title		Year Month Day	01.01.13	01.02.13	01.03.13
5	DOCUMENT TITLE	Size	Dwg No.
6	Document 1	A4	1234-001	A	B	C
7	Doucment 2	A4	1234-002	A	B	C
8	Document 3	A4	1234-003	A	B	C
9
10
11
12
13
14
15
16
17	DISTRIBUTION			No. of Copies
18	Recipient 1	AA		1
19	Recipient 2	BB		2		E
20	Recipient 3	CC		E	2
21
22
23
24
25
26
27
28
29
30	Authorised for issue by:			TT	TT	TT
31	Purpose of issue:			I	I	I
32
33			Issue			Y

<tbody>
</tbody>

Sheet (0)​

---

Here I will try to describe the required end result as best as possible. (Task 1) We currently have conditional highlighting which highlights a particular column when a letter 'Y' is entered into row 33, however, I would prefer this to be triggered by data being entered into the 'Distribution Section' of the worksheet i.e. where 'e' has been entered into cell F19 (Note: the value of this cell will always be 'E' or numbers '1' to '9'). (Task 2) I would also like to highlight the corresponding row; in the example this would be Row 19. (Task 3) When a new date is entered into G4, the previously activated highlighting needs to be removed i.e. Column F should no longer be highlighted and none of the rows in the 'Distribution Section' should be highlighted until any of the cells in the range G18 to G20 have data entered.