Is this a conditional formula, and how do I do it?
 

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 this a conditional formula, and how do I do it?
 

If by * you mean multiplication then how will you multiply a number with text?

Also for conditional formatting you can use the same formula you have shown...

"john" wrote:

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 this a conditional formula, and how do I do it?
 

I don't need it to mulitply text, but I do need it to let me know if the two
values are not the same. Even if it highlights the ones with text as being
incorrect, that is fine. I just can't figure out how to write the formula.

Thanks

"Sheeloo" wrote:

If by * you mean multiplication then how will you multiply a number with text?

Also for conditional formatting you can use the same formula you have shown...

"john" wrote:

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 this a conditional formula, and how do I do it?
 

Select Col C
Choose Format|Conditional Formatting
For condition 1
Choose Formula is and paste this condition
=(A1+B1)C1
Format as you want
For condition 2 Choose Formula is and paste this condition
=(A1+B1)<C1
Format as you want

Do the same for Col D - just use D1 instead of C1

It will ignore text values...

To highlight text in say Col B
use
=ISTEXT(B1)

"john" wrote:

I don't need it to mulitply text, but I do need it to let me know if the two
values are not the same. Even if it highlights the ones with text as being
incorrect, that is fine. I just can't figure out how to write the formula.

Thanks

"Sheeloo" wrote:

If by * you mean multiplication then how will you multiply a number with text?

Also for conditional formatting you can use the same formula you have shown...

"john" wrote:

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.