IF function not working in conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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?
 
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
 
Thanks. That worked. But I didn't put the quotes in - Excel did that all on
its own!
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Conditional formatting on a dynamic range - workaround 1
Conditional Formatting Formula 1
Excel conditional formatting with Weeknum 4
conditional formatting update issue 5
Conditional Formatting 3
vlookup formatting problem 1
copy conditional formatting range 3

Back
Top