Complex formatting help please!

[Routus]

Hi all
I have a datasheet with 20 columns and currently about 10,000 rows (the number of rows will increase regularly).

Column 'A' is event date and time .... there can be anything between 1 and 50 rows per event.

I need to evaluate the cells in columns G, H and I for each event and then colour the highest valued cell (they are all numeric) in each column for each event. Ideally they will be coloured a similar green to the shade used in conditional formatting, as that is being applied to other columns in the sheet.

Can someone explain to me please (or provide code if it has to be vba) how to identify the rows per event and then fill the relevant cell in each column? I'm unsure of how to go about it and have very little VBA knowledge.

Any help greatly appreciated
Thank you
Paul

 

[Cubist]

I don't know but you mean by the green shading but is this close?

Book4
	A						G	H	I
1	Event						Data1	Data2	Data3
2	A						65	44	20
3	A						13	37	79
4	A						55	18	27
5	A						44	70	56
6	A						70	83	69
7	B						64	79	1
8	B						84	99	37
9	B						27	33	97
10	B						85	11	94
11	B						46	87	95
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G2:I11	Expression	=G2=MAXIFS(G$2:G$11,$A$2:$A$11,$A2)	text	NO

 

[Routus]

I don't know but you mean by the green shading but is this close?

Book4
	A						G	H	I
1	Event						Data1	Data2	Data3
2	A						65	44	20
3	A						13	37	79
4	A						55	18	27
5	A						44	70	56
6	A						70	83	69
7	B						64	79	1
8	B						84	99	37
9	B						27	33	97
10	B						85	11	94
11	B						46	87	95
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G2:I11	Expression	=G2=MAXIFS(G$2:G$11,$A$2:$A$11,$A2)	text	NO

Hi Cubist and thanks for your reply.
That is along the lines of what I want to achieve, yes. By the green shading I was referring to the option in Conditional formatting to set cell values to display in green text on a green background ... I would like to use the same colour throughout the sheet if possible. Unfortunately I'm not sure I can adapt that to work over 10,000+ rows?

 

[Cubist]

You'd just have to change the custom format to your desired colour. Select the entire range -> Conditional formatting -> Insert the formula.

Book4
	A						G	H	I
1	Event						Data1	Data2	Data3
2	A						65	44	20
3	A						13	37	79
4	A						55	18	27
5	A						44	70	56
6	A						70	83	69
7	B						64	79	1
8	B						84	99	37
9	B						27	33	97
10	B						85	11	94
11	B						46	87	95
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G2:I11	Expression	=G2=MAXIFS(G$2:G$11,$A$2:$A$11,$A2)	text	NO

 

[Routus]

That's fantastic, many thanks!