View Single Post
 
Old 01-19-2012, 06:46 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows XP Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hello
Select the range to format ( say B2:C2)
Home ribbon
Styles tab
Cond formatting
Click " manage rules" - New rule - Use a formula
Enter
Code:
=B$2=max(B2:C2)
OK

Format as required -Finish

EDIT Replace MAX with MIN if needed
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Last edited by Pecoflyer; 01-19-2012 at 06:59 AM. Reason: Added
Reply With Quote