highlight the whole row based on a max value in column c + shortcut to refresh a sheet

[INN]

Hi
I have this table and what I want to do is 2 things

1) based on the highest %change value, I want to highlight the whole row corresponding to that value in different color.
So I did this formula but it is just highlighting the value in %change column.

=A2=MAX($C$2:$C$6)

By the way, I entered stock symbols and then used Data-->Stock option to enter the High and the %Change for each stock.

2) What is easiest way to refresh a sheet so the values in my sheet will be refreshed. I tried
CTRL+ALT+F5 and it did the job but can I create a short cut or a button in macro maybe to do that? Thank you very much

1.xlsx
	A	B	C
1	Stock Name	High	% Change
2	SKYWORKS SOLUTIONS, INC. (XNAS:SWKS)	$ 96.99	-0.28%
3	ADVANCED MICRO DEVICES, INC. (XNAS:AMD)	$ 79.23	-0.36%
4	NVIDIA CORPORATION (XNAS:NVDA)	$ 172.17	0.87%
5	AMAZON.COM, INC. (XNAS:AMZN)	$ 97.23	-0.16%
6	MICROSOFT CORPORATION (XNAS:MSFT)	$ 256.12	-0.86%
Sheet4

Cell Formulas
Range	Formula
B2:B6	B2	=A2.High
C2:C6	C2	=A2.[Change (%)]

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C6	Expression	=A2=MAX($C$2:$C$6)	text	NO

 

[Fluff]

You would need to use

=$C2=MAX($C$2:$C$6)

What is wrong with using Ctrl Alt F5, it is a shortcut.

 

[INN]

Thank you very much. That works. Thanks. I thought I can create a button (Developer-->Insert-->Form Controls-->Button) and assign CTRL+ALT+F5 to that button (just faster). Thank you again.

 

[Fluff]

Glad to help & thanks for the feedback.