Microsoft Office Forums - View Single Post - Conditional formatting

Thread: Conditional formatting

View Single Post

Old

01-20-2012, 03:04 AM

grizz

grizz is offline

grizz uses Windows XP

Windows XP grizz uses Office 2003

grizz uses Office 2003

Office 2003

Novice

Join Date: Jan 2012

Posts: 28

grizz is on a distinguished road

Default

highlight B2 and C2 go conditional format / formula is

Code:

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

and format your colour

Reply With Quote