Microsoft Office Forums - View Single Post - Challenge!! Need help though. (Conditional formatting)

Thread: Challenge!! Need help though. (Conditional formatting)

View Single Post

Old

02-03-2010, 05:03 PM

ConneXionLost ConneXionLost is offline

ConneXionLost is offline

ConneXionLost uses Windows XP

Windows XP ConneXionLost uses Office 2003

ConneXionLost uses Office 2003

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

ConneXionLost is on a distinguished road

Default

Assuming your range of grades is A1:A5, select the range and add this formula to the Conditional Formatting:

Code:

=A1=MAX($A$1:$A$5)

Adjust your range and reference to the top left cell as necessary.

Cheers,

Reply With Quote