RE: Change colour of Text if number in cell exceed limit

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Rowan" <Rowan@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 1 Aug 2005 18:16:04 -0700

>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?action=getinfo&userid=25712
> View this thread: http://www.excelforum.com/showthread.php?threadid=392015
>
>
.

References:
- Change colour of Text if number in cell exceed limit
  - From: Lewis Koh

Prev by Date: how can I search a field for a particular word
Next by Date: Re: Shortcut keys assigned to macros/functions in excel
Previous by thread: Re: Change colour of Text if number in cell exceed limit
Next by thread: how can I search a field for a particular word
Index(es):
- Date
- Thread