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
8 Replies
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.
Do you mean 9 workbooks? If so: does each workbook have only one worksheet?
