How do you make Conditional Formating work?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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(A1>95,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
 
Select the range of cells then Format>CF>Cell 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
 
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.
 
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 Edit>Paste Special>Add>OK>Esc.

Any better?


Gord
 
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.











- Show quoted text -
Click to expand...

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 =A1>100. Leave the
format alone. Add another condition. This one will be =A1>95.
Change the format so it's red with a red border.

Hope this works for you.

Dorothy
 
Dorothy said:
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 =A1>100. Leave the
format alone. Add another condition. This one will be =A1>95.
Change the format so it's red with a red border.

Hope this works for you.

Dorothy
Click to expand...
 
Back
Top