I need a way to format the color of a cell based on the value of the cell above it. For example if A4=5 A5=6 A6=6 A7=3 then I want cells A5 and A6 to be highlighted. This only needs to be highlighted if adjacent cells are of the same value. Can this be done?
THX in advance