From the menus:
Format Conditional Formatting Cell Value Is greater than 100. Set
required fomat.

Regards
Rowan

"Lewis Koh" wrote:


Is it possible to set a limit to the number in the cell to switch its
colour? Example: seting cell A1 to change it's text to "red" after
exceeds 100.


--
Lewis Koh
------------------------------------------------------------------------
Lewis Koh's Profile: http://www.excelforum.com/member.php...o&userid=25712
View this thread: http://www.excelforum.com/showthread...hreadid=392015