If you type in the = sign at the beginning of the formula, you'll probably
get what you asked for, but if you leave it out, Excel will usually add not
only the = sign but also the quotes. It's always safest to check what
you've ended up with.
--
David Biddulph

"DruD" wrote in message
...
Thanks. That worked. But I didn't put the quotes in - Excel did that all
on
its own!
--
DruD


"Elkar" wrote:

You'll need to remove the quotes. As written, Excel is looking for the
text
string "$C2$B2". The formula should be =$C2$B2.

HTH,
Elkar


"DruD" wrote:

This is the formula: ="$C2$B2". Comparing one column of values to
another,
with the intent of formatting (highlighting in blue) rows that meet the
condition. Does this help?
--
DruD


"Elkar" wrote:

It would help if you provided the formula. Also, an example of the
data
being affected. What you expect to happen, and what is happening.
Perhaps
there is something wrong that you're just not seeing?

HTH,
Elkar


"DruD" wrote:

I'm trying to apply conditional formatting to a spreadsheet using
the IF
function. I know I'm using the correct formula. But the
formatting is not
being applied. It's like the function is not working.
--
DruD