Conditional formatting problem

  • Thread starter Thread starter Coco212
  • Start date Start date
C

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