P

#### Pappy

I have a spreadsheet in which I have two different formula in two

different cells. What I'm trying to do is set up a conditional

formatting formula that looks at the RESULT of the formula in one cell,

compares it to the RESULT of the formula in the other cell.

For example, in one cell (F2) I have the formula: "=COUNTIF($E$5:$E$735,

$E$2) In one instance, this formula returns a "1".

In another cell (I2), I have the formula "=IF(ISNA(VLOOKUP($E$2,_

000A9643CL,3,FALSE)),"",(VLOOKUP($E$2,_000A9643CL,3,FALSE)))". This

formula returns a "3".

What I'm trying to do with my conditional formatting is compare the

RESULTS of these two cell formulas and if they (the RESULTS) don't

match, I want to highlight the array as yellow. If the RESULTS of these

two cell formulas are the same, I want to highlight the array as green.

Can anyone help me with this? I will certainly appreciate it. I have a

feeling that I can't do what I want to do.

V/R

Pappy