+ Reply to Thread
Results 1 to 10 of 10

detect the 3 patterns, bigger smaller and equal with the colors.

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    detect the 3 patterns, bigger smaller and equal with the colors.

    detect the 3 patterns, bigger smaller and equal with the colors,
    you always have to use the last draw for next to see the three patterns in each of the 5 blocks
    https://www.excelforum.com/attachmen...1&d=1555075970
    Attached Files Attached Files

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: detect the 3 patterns, bigger smaller and equal with the colors.

    You can do this with conditional formatting formulas like

    =(A1<A2)
    =(A1=A2)
    =(A1>A2)

    The extra blank columns in the results section are easily accounted for.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: detect the 3 patterns, bigger smaller and equal with the colors.

    hello MIKE, okay, you can put it in the worksheet, please

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: detect the 3 patterns, bigger smaller and equal with the colors.

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
    Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

    Jorel: you have been a member long enough not to have to be reminded of our rules. You should know better.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: detect the 3 patterns, bigger smaller and equal with the colors.

    detect the 3 patterns, bigger smaller and equal with the colors.

  6. #6
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: detect the 3 patterns, bigger smaller and equal with the colors.

    Okay, I agree, but I did not answer, now where am I going to ask for help?

  7. #7
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: detect the 3 patterns, bigger smaller and equal with the colors.

    jorel read AliGW's post again. The instructions are there.
    Dave

  8. #8
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: detect the 3 patterns, bigger smaller and equal with the colors.

    Okay, but I need the solution!
    there is another forum of excel that can
    * help me? please

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: detect the 3 patterns, bigger smaller and equal with the colors.

    Jorel - you know very well what you have to do. Look back at this thread where you finally provided the link requested: https://www.excelforum.com/excel-pro...ch-groups.html

    Just as then, you will get NO FURTHER HELP here until you have provided the cross post link.

    You have had three warnings now regarding cross posting. If you respond again to this thread WITHOUT providing the link requested, you may well find yourself serving a ban from posting here.

  10. #10
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: detect the 3 patterns, bigger smaller and equal with the colors.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to change a value according to a rule - bigger than, smaller than
    By olibeira in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-26-2017, 04:40 PM
  2. Image Scale To Fit as the sheet scales bigger or smaller ?????
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2016, 11:34 AM
  3. Replies: 20
    Last Post: 08-02-2012, 10:48 AM
  4. Embedded bigger than smaller than-IF issue
    By shredster7 in forum Excel General
    Replies: 3
    Last Post: 07-13-2009, 08:27 AM
  5. formula to check bigger and smaller than
    By avengine in forum Excel General
    Replies: 1
    Last Post: 12-26-2008, 03:13 PM
  6. [SOLVED] Font size smaller and bigger in a formula
    By Gary T in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-10-2006, 11:55 AM
  7. [SOLVED] How to find value that is bigger or smaller than 2SD?
    By learner in forum Excel General
    Replies: 8
    Last Post: 05-11-2005, 05:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1