Forum Discussion
How can I highlight lowest value in multiple excel sheet?
Let's say you have data in A1:F20 on Sheet A, Sheet B and Sheet C.
Select A1:F20 on Sheet A.
A1 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=A1=MIN('Sheet A'!$F$1:$F$20, 'Sheet B'!$F$1:$F$20, 'Sheet C'!$F$1:$F$20)
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.
Do the same on Sheet B and Sheet C.
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.