Excel: use conditional formatting to highlight (background) F TO J in green if they stay the same and yellow if they cha
Posted: Fri May 20, 2022 5:42 am
Excel:
use conditional formatting to highlight (background) F TO J in
green if they stay the same and yellow if they change.
А B с D E use conditional formatting to highlight (background) F TO J in green if they stay the same and yellow if they change. 1 1 0 0 1 1 0 0 0 0 1 0 0 0 1 1 0 0 0 1 F G H I J >change colour 0 1 1 0 1 0 1 0 1 0 1 1 1 0 1 1 1 1 - No change colour 0
use conditional formatting to highlight (background) F TO J in
green if they stay the same and yellow if they change.
А B с D E use conditional formatting to highlight (background) F TO J in green if they stay the same and yellow if they change. 1 1 0 0 1 1 0 0 0 0 1 0 0 0 1 1 0 0 0 1 F G H I J >change colour 0 1 1 0 1 0 1 0 1 0 1 1 1 0 1 1 1 1 - No change colour 0