J
john
I'm sure this is simple, but I cannot seem to wrap my mind around it. This
is what I have:
COLUMNS:
F H I J
ROW 1: .5 .5 1 1
ROW 2: 1 1 2 1
ROW 3: .5 .5 1 MO
ROW 4: 2 X 2 1
I need some kind of formula that will calclulate (for example) if F1+H1 is
equal to I1*J1, then highlight I1 and/or J1 if it is not.
is what I have:
COLUMNS:
F H I J
ROW 1: .5 .5 1 1
ROW 2: 1 1 2 1
ROW 3: .5 .5 1 MO
ROW 4: 2 X 2 1
I need some kind of formula that will calclulate (for example) if F1+H1 is
equal to I1*J1, then highlight I1 and/or J1 if it is not.