Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts
    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
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Posting Permissions

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