# Conditional formatting each next step

#### Kishan

##### Well-known Member
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

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
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
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
You're welcome & thanks for the feedback

Replies
2
Views
394
Replies
2
Views
235
Replies
1
Views
506
Replies
5
Views
366
Replies
0
Views
541

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.

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.

### Which adblocker are you using?

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

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