Conditionally Format Based on Adjacent or Previous value

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