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

Post your formula

"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

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

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

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

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

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.


"DruD" wrote:

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

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