1. ## Identifying peaks

I have columns of values which would form out irregular waves. and they formed peaks at different cells.

How to do I highlight all the peaks together, in such that those peaks are highlighted in white wordings

0.000309434 0.000464444 0.000447813
0.000314096 0.000378081 0.000683614
0.000415646 0.000311915 0.000502104
0.00025374 0.000598214 0.000496079
0.000891225 0.000836371 0.001050418
0.000768889 0.00047441 0.001532572
0.000874906 0.000980262 0.000871278
0.001294562 0.002801118 0.00151461
0.006437943 0.00423406 0.003050491
0.009185974 0.00673786 0.009234774
0.009284196 0.015849873 0.022791281
0.004705332 0.009599119 0.013764003
0.002977404 0.005420946 0.010224208
0.002006252 0.00335079 0.004401876
0.001843602 0.002750495 0.003512435
0.000544915 0.000758949 0.001595207
0.000805583 0.000966159 0.00152905
0.003515476 0.003909257 0.005720271
0.000607175 0.001594123 0.004116213
0.004224081 0.005085689 0.001947054
0.005664855 0.006400748 0.000194971
0.010562649 0.006213763 0.000589064

I have been doing the highlight manually which is very time consuming, whoever that have an idea of solving this please help! Thank you very much

2. You can use conditional formatting to apply your highlighting.

Assuming that data is sitting in an Excel spreadsheet from cells A1:C22 you do the following steps

Select the range A1:C22
Go to Home > Conditional Formatting > New Rule
Select Use a formula to determine which cells to format
The formula to use is: =A1=Max(1:1)
Click the format button and add the required formatting
Click OK

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•