Select cells A1 through A10.

Then Select Conditional Formatting from the Format Menu.

Select Is Greater Than from the middle drop down and enter 40 in the
right drop down.

Then click Format, select colour from the Font Tab.

Then Click Ok twice.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=497109