Either your cell doesn't meet the condition you specified, or you
didn't pick a color for your condition.

If you are still having trouble you might need a visual aid -- check
out http://www.contextures.com/xlCondFormat01.html

HTH,
JP


On Nov 15, 7:06 pm, 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.- Hide quoted text -

- Show quoted text -