Here are the steps to take...<br />
<br />
Select the *entire* range C6:AG6 starting from cell C6.<br />
Cell C6 will be the active cell. The active cell is the<br />
one cell in the selected range that is not shaded. The<br />
formula will be relative to the active cell.<br />
<br /><br />
Goto the Home tab-Styles-Conditional Formatting-Manage rules-<br />
New rule-Use a formula to determine which cells to format<br />
<br /><br />
Enter this formula in the box below:<br />
<br /><br />
=COLUMN()=MAX(($C$7:$AG$18=MAX($C$7:$AG$18))*COLUMN($C$7:$AG$18))<br />
<br /><br />
Click the Format button<br />
Select the desired style(s)<br />
OK out