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
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.
