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.
Excel A To E Are The Original Data Compared Under The Conditions Of 1 And 0 Below If There Is Any Difference The Corr 1 (60.07 KiB) Viewed 64 times
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!