Conditional Formating - Column and Row Highlighting

Tim Ball

New Member
Joined
Nov 5, 2013
Messages
2
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

New Member
Joined
Nov 5, 2013
Messages
2
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.[HR][/HR] 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)

[HR][/HR]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.
 

Forum statistics

Threads
1,081,747
Messages
5,361,038
Members
400,610
Latest member
ebey

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top