excel A to E are the original data, compared under the conditions of 1 and 0 below. If there is any difference, the corr
Posted: Fri May 20, 2022 5:51 am
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
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 65 times