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

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

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

Formula:

Please Login or Register  to view this content.

Artik

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.

@ 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