Quote:
Originally Posted by genevievebr0
I will have to ask if it is possible to convert the text "numbers" to numbers.
|
If they can't be, it's quite easy to do within Excel.
Quote:
|
1) I need to apply the same rule to many rows (example, row 4 to 500), how would the formulas look like?
|
I suspected as much. I see you use Excel 2010. In earlier versions, the limit on the number of rules for any given range was 3. As far as I know, there is no such limit now.
Would the format of your sheet be essentially the same as what you posted here without the Issue column? I could combine the rules and apply them over all the rows if you like.
Quote:
|
2) Also, it could be possible that two rules apply for the same cell. How does Excel manage those? Does it take only the first rule? Would it put the cell in two colors if I put different colors for each formula?
|
As I mentioned above, there is no limit to the number of rules you can have. However, if two rules conflict, the topmost rule takes precedence. Thus you may have a problem if you have more than one rule that should process i.e. if you have an hour conversion and repeated codes.
However, if you are correcting these as you see the colors, you could just work your way through them until all the formatting is gone.