IF function not working in conditional formatting

D

DruD

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.
 
E

Elkar

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
 
D

DruD

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?
 
E

Elkar

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
 
E

Elkar

You probably didn't include the = sign when you typed the formula. Thus,
Excel assumed you were looking for a text string rather than a formula.
 
D

David Biddulph

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.
 
Top