Conditionally Format Based on Adjacent or Previous value neha sharma 3 years ago Microsoft Excel Tips and Tricks I demonstrate how to conditionally format cells based on an adjacent or previous value. This value is normally in the cell above or to the left. Credit Chester Tugwell