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
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
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.
hello MIKE, okay, you can put it in the worksheet, please
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
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?
jorel read AliGW's post again. The instructions are there.
Dave
Okay, but I need the solution!
there is another forum of excel that can
* help me? please
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks