I KNOW I am being incompetent but must humbly plead for help:
cell p3 has the number 412 in it
cell t3 has the number 470 in it
I want p3 to be highlighted in red if it is a number that is less than t3
so I used conditional formatting, use a formula, and wrote this for the
formula, "=if<T3" and chose the format as the color bright, dark, pink
and nothing happens
I had copied the numbers from a webpage, so I tried using sugggestions from
pervious questions/answers about getting rid of html codes:
find alt + 0160, replace (nothing)
and nothing happened
I tried "data, text toi columns, finish"
nothing happened.
any help would be greatly appreciated!
Synthia

Use a formula of

=P3<T3

--

HTH

Bob

"Coco212" wrote in message
...
I KNOW I am being incompetent but must humbly plead for help:
cell p3 has the number 412 in it
cell t3 has the number 470 in it
I want p3 to be highlighted in red if it is a number that is less than t3
so I used conditional formatting, use a formula, and wrote this for the
formula, "=if<T3" and chose the format as the color bright, dark, pink
and nothing happens
I had copied the numbers from a webpage, so I tried using sugggestions
from
pervious questions/answers about getting rid of html codes:
find alt + 0160, replace (nothing)
and nothing happened
I tried "data, text toi columns, finish"
nothing happened.
any help would be greatly appreciated!
Synthia

=P3<T3

Conditional Formatting works with BOOLEANs, so your formula must return
either TRUE or FALSE. If TRUE, it performs the formatting, else it check
condition 2 or exits.

"Coco212" wrote:

I KNOW I am being incompetent but must humbly plead for help:
cell p3 has the number 412 in it
cell t3 has the number 470 in it
I want p3 to be highlighted in red if it is a number that is less than t3
so I used conditional formatting, use a formula, and wrote this for the
formula, "=if<T3" and chose the format as the color bright, dark, pink
and nothing happens
I had copied the numbers from a webpage, so I tried using sugggestions from
pervious questions/answers about getting rid of html codes:
find alt + 0160, replace (nothing)
and nothing happened
I tried "data, text toi columns, finish"
nothing happened.
any help would be greatly appreciated!
Synthia

I have the same problem


"Bob Phillips" wrote:


Use a formula of

=P3<T3

--

HTH

Bob

"Coco212" wrote in message
...
I KNOW I am being incompetent but must humbly plead for help:
cell p3 has the number 412 in it
cell t3 has the number 470 in it
I want p3 to be highlighted in red if it is a number that is less than t3
so I used conditional formatting, use a formula, and wrote this for the
formula, "=if<T3" and chose the format as the color bright, dark, pink
and nothing happens
I had copied the numbers from a webpage, so I tried using sugggestions
from
pervious questions/answers about getting rid of html codes:
find alt + 0160, replace (nothing)
and nothing happened
I tried "data, text toi columns, finish"
nothing happened.
any help would be greatly appreciated!
Synthia



.