![]() |
#2
|
||||
|
||||
![]()
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) 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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
zeppelinmike | Excel | 1 | 11-13-2011 08:05 AM |
![]() |
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
![]() |
namedujour | Excel | 3 | 08-25-2011 01:46 PM |
![]() |
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |
![]() |
djreyrey | Excel | 3 | 06-03-2011 01:54 AM |