Forum Discussion
Applying a set of rules if a condition based on a different column, same row, is satisfied
RICARDO JULIO RODRIGUEZ FERNANDEZ
Updated the Cond. Format. rule I earlier shared according to what I understood - Hope this is OK this time
Updated your 2nd rule according to what I suspect you want to get (not sure at all...)
Thanks, Lorenzo! It is not easy for me to understand how things work! After studying the new sheet for a while, I found the Name Manager, and things are a bit clearer now.
Concerning what values must be considered, figures in [ects_pass_p] must be taken into account only when [stem] = 1, and the format must be applied to the top 8. I realize now that the objective is no longer to apply the format conditionally, but to correctly select the values and apply the format to all of them. How must I modify the rule to get the 8 top values formatted?
Although I see you are able to get what I'm trying, the interface and the concepts are very confusing to me. For instance, I'm attaching a new release of the workbook. I added a new rule to [ects_pass_p]. I'm not able to understand why it doesn't accept the appearance of that column, whatever order is set.
Thanks for your time!
RICARDO JULIO RODRIGUEZ FERNANDEZ
Updated the Cond. Format. rule I earlier shared according to what I understood - Hope this is OK this time
Updated your 2nd rule according to what I suspect you want to get (not sure at all...)
- Although I marked as the best response, I want to thank you for your help! Your solution introduced to me several very useful concepts I was not using yet. A lot to learn about Microsoft tool scape! Thanks!