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" <(E-Mail Removed)> wrote in message
newsD34C8C2-C366-4744-8E8D-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> newsD34C8C2-C366-4744-8E8D-(E-Mail Removed)...
> >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
> >
>
>
> .
>