Hi,
1) I need to apply the same rule to many rows (example, row 4 to 500), how would the formulas look like?
Quote:
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.
|
A- It would be nice if you could apply the rules to all of the rows. If there is no limit to the number of rows, could you put the rules from row 4 to 1000?
B- I unhidded all the columns so you can see the exact document that I will be using.
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?
Quote:
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.
|
A) I am not the one who will be correcting the issues. My job will be identify the issues and send them to the Team leaders who will need to verify the data and correct if necessary on a SharePoint file. So it won't be possible for me to see the different rules.
Besides having one rule with the "fill" in a color, another rule with the font in a different color, would you have any other suggestions?
Thanks again!
