Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |