Conditional formatting each next step

Kishan · Nov 5, 2019

Using Excel 2000
Hi,

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"

Book1

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

1

2

3

4

1

X

5

P1

P2

P3

P4

P5

P6

P7

P8

P9

P10

P11

P12

P13

P14

6

X

1

2

1

2

1

2

X

1

X

1

7

X

2

1

X

1

2

1

X

2

1

8

X

1

2

1

2

1

2

X

1

X

1

9

2

1

X

2

1

X

1

2

1

10

1

X

1

X

1

2

1

X

1

11

X

2

X

2

X

1

2

1

2

12

X

1

2

1

2

1

X

1

X

1

13

1

X

2

1

X

1

2

1

X

1

14

1

2

X

1

X

1

X

15

1

X

1

X

1

2

X

1

16

X

1

X

2

1

2

X

1

X

17

1

X

1

2

1

X

1

2

1

X

1

18

1

X

1

2

X

1

19

X

1

X

1

2

1

X

20

1

2

1

X

1

2

X

1

X

2

21

1

2

1

X

1

2

1

X

1

22

2

1

X

1

X

1

2

1

2

23

1

2

1

2

1

X

1

24

X

1

2

1

2

1

X

1

X

25

1

X

1

26

X

1

2

1

X

1

X

1

27

1

2

X

1

2

1

X

1

28

1

2

1

2

X

1

X

1

X

29

1

2

1

X

1

X

1

2

1

X

2

30

1

X

1

X

1

X

1

2

31

1

X

1

32

1

X

1

2

1

X

1

X

2

1

33

2

1

X

1

X

2

1

2

1

X

1

34

1

X

1

2

1

X

1

X

1

35

2

1

2

X

1

X

1

X

1

36

1

X

2

1

2

X

1

X

1

2

X

37

X

2

X

2

X

1

2

1

2

38

1

2

1

2

1

X

1

39

1

2

1

X

1

X

1

2

1

X

2

40

41

42

43

Sheet5

Thank you in advance

Regards,
Kishan

Fluff · Nov 5, 2019

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 · Nov 5, 2019

Fluff said:
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! 

Kind Regards,
Kishan

Fluff · Nov 5, 2019

You're welcome & thanks for the feedback

Conditional formatting each next step

Kishan

Well-known Member

Excel Facts

Fluff

MrExcel MVP, Moderator

Kishan

Well-known Member

Fluff

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

Conditional formatting each next step

Kishan

Well-known Member

Excel Facts

Fluff

MrExcel MVP, Moderator

Kishan

Well-known Member

Fluff

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock