How do you make Conditional Formating work?
 

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.

How do you make Conditional Formating work?
 

Let's say A1:A11 contains the numbers 90 through 100

1. Highlight the entire range
2. Go to Format, Conditional Formatting
3. Choose Formula Is, type "=AND(A195,A1<100)" (without quotes)
4. Click Format, Patterns tab, choose appropriate color
5. Click OK twice.

Check out http://www.contextures.com/xlCondFormat01.html for more
info.

Hey I just did your homework for you?

HTH,
JP



On Nov 14, 5:10 pm, 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.

How do you make Conditional Formating work?
 

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.

How do you make Conditional Formating work?
 

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.

How do you make Conditional Formating work?
 

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.

How do you make Conditional Formating work?
 

On Nov 15, 4: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 -

Hi there. Let's start with the first cell that contains a number.
Let's say that cell is A1. Go to "Format" then "Conditional
Formatting". Choose "Formula is" and type in =A1100. Leave the
format alone. Add another condition. This one will be =A195.
Change the format so it's red with a red border.

Hope this works for you.

Dorothy

How do you make Conditional Formating work?
 

"Dorothy" wrote:

On Nov 15, 4: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 -

Hi there. Let's start with the first cell that contains a number.
Let's say that cell is A1. Go to "Format" then "Conditional
Formatting". Choose "Formula is" and type in =A1100. Leave the
format alone. Add another condition. This one will be =A195.
Change the format so it's red with a red border.

Hope this works for you.

Dorothy

How do you make Conditional Formating work?
 

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 -