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.