![]() |
|
#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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
IF and Conditional Formatting - Ver.2003
|
zeppelinmike | Excel | 1 | 11-13-2011 08:05 AM |
Conditional formatting with AND, OR
|
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
| Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |
help with conditional formatting
|
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |
* Conditional Formatting MS 2010
|
djreyrey | Excel | 3 | 06-03-2011 01:54 AM |