Conditional formatting problem

[Coco212]

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

 

[Bob Phillips]

Use a formula of

=P3<T3

 

[Sean Timmons]

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

 

[samrah]

I have the same problem

Use a formula of

=P3<T3

--

HTH

Bob




.