Conditional formatting each next step

Kishan

Well-known Member
Joined
Mar 15, 2011
Messages
1,561
Using Excel 2000</SPAN></SPAN>
Hi,</SPAN></SPAN>

Here the below is my example I need Formula is preferable or an alternative VBA for conditional formatting to highlight each next step pattern in the complete row as per "specific pattern shown in the cells C4, D4 & E4 which is changeable as required" </SPAN></SPAN>


Book1
ABCDEFGHIJKLMNOPQR
1
2
3
411X
5P1P2P3P4P5P6P7P8P9P10P11P12P13P14
6X11121212X11X1
7XX21XX1121X211
8X11121212X11X1
9211X21X1122111
101X1X11211XXX11
11X2XX2X11211112
12X112111211X1X1
131XX21X111211X1
141112XXX1XX1XXX
151XX11111X112X1
16X1X212XXX111XX
1711X121X11121X1
1811111X11122X11
19X11XX1111211XX
20111121XX12X1X2
211112211X1211X1
2221X11X11121112
231111121121XXX1
24X11211211X111X
251111X111111111
26X1111211XX11X1
2712XXXX12111X11
28111212XXXX1X1X
29111221X1X121X2
30111X111X11X112
31111X1111111111
321X11211XXX1X21
332211X1X21221X1
341X12111111X1X1
3521112X1XX11XX1
361XX2112X11X12X
37X2XX2X11211112
381111121121XXX1
39111221X1X121X2
40
41
42
43
Sheet5


Thank you in advance</SPAN></SPAN>

Regards,</SPAN>
Kishan</SPAN></SPAN>
 
Last edited:

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
73,207
Office Version
  1. 365
Platform
  1. Windows
Maybe
=OR(AND(C6=$C$4,D6=$D$4,E6=$E$4),AND(B6=$C$4,C6=$D$4,D6=$E$4),AND(A6=$C$4,B6=$D$4,C6=$E$4))
 

Kishan

Well-known Member
Joined
Mar 15, 2011
Messages
1,561
Maybe
=OR(AND(C6=$C$4,D6=$D$4,E6=$E$4),AND(B6=$C$4,C6=$D$4,D6=$E$4),AND(A6=$C$4,B6=$D$4,C6=$E$4))
Fluff, thank you very much for the formula it worked absolutely okay! </SPAN></SPAN>

Kind Regards,
</SPAN>
Kishan
</SPAN></SPAN>:)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
73,207
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,934
Messages
5,834,471
Members
430,288
Latest member
Shinoy98

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top