conditional formatting or VBA for highlighting rows

[lemmo80]

Hi, help please!
I never done a VBA so not sure where to start and hoping I can use conditional formatting instead as I'm semi-familiar with it.

What I would like is to use a traffic light system depending on what data is entered into 2 separate columns.

• turn row amber if column H & J are empty
• turn row green if column H is filled
• turn row red if column J is filled
• thatch row red if both H & J are filled

Column H will contain a “general – no specific” formatting and J will contain “short date” formatting.

If I need a VBA could you please point me to a "guide for dummies" tutorial as I see codes written on other threads but have no idea where to actually start typing them.

many thanks in advance,

NEW - database register - EXTERNAL COPY carpark v2.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Form inserted	SubmissionCodeField	Surname	Colour	Parking Commencement Date	Parking Type	I agree to the Terms and Conditions	Car Space Allocated	Card Access Setup Y/N	Date User Terminated from Carpark Use	HISTORICAL DATA Car Space Allocated
2	24/05/2021	SHCP-17	jones	White	24/05/2021	HIE residing staff	Yes	2A01
3	31/05/2021	SHCP-31	joe	Black	31/05/2021	HIE commuting staff	Yes	9A01
4	31/05/2021	SHCP-32	josman	Silver	31/05/2021	HIE commuting staff	Yes	9A02
5	31/05/2021	SHCP-33	jettson	Silver	31/05/2021	HIE commuting staff	Yes	9A03
6	1/06/2021	SHCP-34	jabba	White	1/06/2021	HIE commuting staff	Yes	9A04
7	1/06/2021	SHCP-35	hut	Black	1/06/2021	HIE commuting staff	Yes	9A05
8	1/06/2021	SHCP-36	vadar	White	1/06/2021	HIE commuting staff	Yes	9A06
9	2/06/2021	SHCP-37	trooper	White	2/06/2021	HIE commuting staff	Yes	9A07
10	3/06/2021	SHCP-38	fett	Dirty Silver	3/06/2021	HIE commuting staff	Yes	9A08
11	3/06/2021	SHCP-39	mando	Blue	3/06/2021	HIE commuting staff	Yes	9A09
12
REGISTER

 

[Peter_SSs]

Welcome to the MrExcel board!

Something like this? (The 'thatching' doesn't show up with XL2BB but is there, assuming the image further below is the sort of thing you are after)

21 06 10.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1
2	data	data	data	data	data	data	data		data		data
3	data	data	data	data	data	data	data	data	data		data
4	data	data	data	data	data	data	data		data	data	data
5	data	data	data	data	data	data	data	data	data	data	data
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:K5	Expression	=AND($H2<>"",$J2<>"")	text	NO
A2:K5	Expression	=AND($H2<>"",$J2="")	text	NO
A2:K5	Expression	=AND($H2="",$J2<>"")	text	NO
A2:K5	Expression	=$H2&$J2=""	text	NO

 

[lemmo80]

wow! thank you so much, worked a treat and was easy to follow.
I appreciate the super speedy response too. So glad I found this group

 

[Peter_SSs]

You are very welcome. Thanks for the follow-up.