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.

Select the I cells to be tested and in conditional format use this formula:
=F1+H1=I1*J1
set actual format as needed
Select the J cells to be tested and in conditional format use this formula:
=IF(ISERROR(F1+H1<I1*J1),TRUE,IF(F1+H1<I1*J1,TRU E,FALSE))
set actual format as needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"john" wrote in message
...
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.

THANK YOU THANK YOU THANK YOU!!! That worked!!

"Bernard Liengme" wrote:

Select the I cells to be tested and in conditional format use this formula:
=F1+H1=I1*J1
set actual format as needed
Select the J cells to be tested and in conditional format use this formula:
=IF(ISERROR(F1+H1<I1*J1),TRUE,IF(F1+H1<I1*J1,TRU E,FALSE))
set actual format as needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"john" wrote in message
...
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.

My Halloween treat!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"john" wrote in message
...
THANK YOU THANK YOU THANK YOU!!! That worked!!

"Bernard Liengme" wrote:

Select the I cells to be tested and in conditional format use this
formula:
=F1+H1=I1*J1
set actual format as needed
Select the J cells to be tested and in conditional format use this
formula:
=IF(ISERROR(F1+H1<I1*J1),TRUE,IF(F1+H1<I1*J1,TRU E,FALSE))
set actual format as needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"john" wrote in message
...
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.