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