Conditional formatting

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional formatting

01-20-2012, 03:04 AM

grizz

Windows XP Conditional formatting

Office 2003

Novice

Join Date: Jan 2012

Posts: 28

highlight B2 and C2 go conditional format / formula is

Code:

=RANK(B2,$B$2:$C$2)=1

and format your colour

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:05 AM.