Forum Discussion
How can I highlight lowest value in multiple excel sheet?
Dear Community, I am desperately trying my luck here in this community. Can anyone help me how to highlight lowest value in multiple excel sheet? Thank you in advance for your help
hans,
I need to do comparisons between the files to the
identical cells from file 1-9. Here I need to find the
lowest value and get it marked in a color.
Do you mean 9 workbooks? If so: does each workbook have only one worksheet?
- Exactly
This is not a good idea. Excel does not allow references to other workbooks in a conditional formatting rule.
Move the nine sheets into one workbook. You can then use the method I described in my first reply.
HansVogelaar Sorry, my mistake, they all are under one workbook