conditional formatting with numbers and text

[Guest]

I have a cell in a worksheet that is will have two types of inputs: numeric
range from 3,000 to 150,000, and also the word "hourly"

I have conditionally formatted this cell to highlight when the value is
10,000 or greater. the conditional formatting also extends to other cells in
the same row to be highlighted as well.

my problem is that when i enter the text "hourly", the conditional
formatting is triggered and all the cells are highlited. i do not want that
to happen.

any ideas are greatly appreciated.

i think excel is evaluating the word to large number, but i am not sure.

 

[Peo Sjoblom]

You need to edit the conditions, use formula is as opposed to cell value and
then test for number

as an example

=AND(ISNUMBER(A1),A1>10000)

that is because text is always greater than a number in Excel
the above will not trigger since the first condtion will be false

Regards,

Peo Sjoblom