Maybe your "numbers" are not numbers but text?

In an adjacent column enter =ISNUMBER(cellref).

Do myou get TRUE or FALSE?

If FALSE, format all to General.

Copy an empty cell and select your range then EditPaste SpecialAddOKEsc.

Any better?


Gord

On Thu, 15 Nov 2007 16:06:01 -0800, Stupac09
wrote:

I still can't get it to changee Color. I enter it and it does nothing when I
click ok. It doesn't change color or anything.

"Gord Dibben" wrote:

Select the range of cells then FormatCFCell Value is:

between 95 and 100

Format to red pattern and red border and OK your way out.

Note: set the border color before selecting the type of border or it will
default to Automatic even if you select a color.

BTW.......red border around a red cell will not not show up.


Gord Dibben MS Excel MVP

On Wed, 14 Nov 2007 14:10:00 -0800, Stupac09
wrote:

I am working on homework and have to do conditional formating on excel. I
can not seem to get it to do what I need to do. I click on format and
conditional format. I need to Highlight all numbers between 95 and 100 in
red with a red border. I put it in the dialog box with cells highlighted and
doesn't do anything.