Conditional Formatting Based On Formula Values

[Pappy]

I've looking high and low for a solution to my problem.

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

 

[isabelle]

hi Pappy,

=IFERROR(EXACT($F$2,$I$2),"FALSE")

isabelle

Le 2013-09-19 11:08, Pappy a écrit :

 

[Pappy]

Thanks. I'll try this. I'm somewhat of a newbie when it comes to Excel
formula.