Hi,
I am using Excel 2010. I am trying to get conditional formatting to colour a cell red if there is 2 or more or 2 less between two cells.
ie L leg cell Z6 and R leg cell AB6:
if L=3 and R=4 Both cells Z6 and AB6 stay clear.
if L=2 and R=4 both cells Z6 and AB6 should turn red.
if L=1 and...