excel

A to E are the original data, compared under the conditions of 1 and 0 below. If there is any difference, the corresponding letters (F to J) change colour. You need to use conditional formatting to highlight (background) F TO J in green if their 1 and 0 stay the same as A to E, and yellow if their 1 and 0 change.

A B D E use conditional formatting to highlight (background) F TO J in green if they stay the same and yellow if they change. Original data without any change 1 0 1 0 0 0 0 1 1 1 O O O OOO 1 0 0 0 0 0 1 Compare F G H I J Schange colour iz No change colour 0 1 0 1 0 1 0 1 1 1 1 1 1 1 0