Thread
:
Conditional formatting
View Single Post
01-19-2012, 06:46 AM
Pecoflyer
Windows XP
Office 2003
Expert
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
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
Pecoflyer
View Public Profile
Find all posts by Pecoflyer