Home |
Search |
Today's Posts |
#1
|
|||
|
|||
conditional formatting with numbers and text
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. |
#2
|
|||
|
|||
conditional formatting with numbers and text
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),A110000) 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 "Daniel" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to reformat numbers stored as text (apostrophe at beginning) | Excel Discussion (Misc queries) | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |