Conditional Format for cycle of 0&1 or 1&0

[Motilulla]

Using Excel 2010
Hello,

Conditional Format for cycle of 0&1 or 1&0

I need Conditional Format (change 2 colour) for each of 2 columns when cycle of 0&1 or 1&0 is completed. Please help.

Regards,
Moti

[Artik]

Select the range C6:D67, set conditional formatting for the formula:

Please Login or Register  to view this content.

Artik

[Akuini]

Try this:
It's just for col C.
You can amend the code for col D by changing the range to suit.

Please Login or Register  to view this content.

[Motilulla]

@ Artik, this does not worked as I request…Col (C & D) are different so cycle has to checked in independent column for 0&1 or 1&0. Please take a look example work book attached. Thank you.

Regards,
Moti

[Motilulla]

Try this:
It's just for col C.
You can amend the code for col D by changing the range to suit.

Hello Akuini, this is exactly what I wanted. I admire your help. Thank you.

Kind Regards,
Moti

[Akuini]

You're welcome, glad to help & thanks for the feedback.