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
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 |
