Multiple conditional formats
 

I need help with conditional formatting. Basically I want to compare the
values in 3 cells, and have the special format apply to the highest value. I
have 2 problems:

1. I found out how to do conditional formatting, and to set up multiple
conditions. But, it seems this is an "or" instead of an "and" function. I
need the cell to be formatted if it meets both conditions (i.e. greater than
the values in both cells it is being compared to)

2. When I go to conditional formatting, I can only change the font style.
Font size is "greyed out", and there is no option to highlight the cell a
specific color.

Multiple conditional formats
 

I'd try

Formula Is =max($A$1:$A$3)
Change the range as needed

To highlight the cell, use the PATTERNS tab.
--
HTH,
Barb Reinhardt



"richzip" wrote:

I need help with conditional formatting. Basically I want to compare the
values in 3 cells, and have the special format apply to the highest value. I
have 2 problems:

1. I found out how to do conditional formatting, and to set up multiple
conditions. But, it seems this is an "or" instead of an "and" function. I
need the cell to be formatted if it meets both conditions (i.e. greater than
the values in both cells it is being compared to)

2. When I go to conditional formatting, I can only change the font style.
Font size is "greyed out", and there is no option to highlight the cell a
specific color.

Multiple conditional formats
 

What version of Excel are you using?

I need the cell to be formatted if it meets both conditions
(i.e. greater than the values in both cells it is being compared to)

That's just a single condition.

Font size is "greyed out", and there is no option to highlight the cell a
specific color

In versions prior to Excel 2007 you can't change the font size using
conditional formatting. When you goto the menu FormatConditional Formatting
and click the Format button there should be 3 tabs to choose from, Font,
Borders and Patterns. To format a cell fill color you want to choose the
Patterns tab.

Assume you want to use conditional formatting to highlight the maximun value
in the range A1:C1.

Select the range A1:C1 so that A1 is the active cell. The active cell is the
one that is not "blueish".

Goto the menu FormatConditional Formatting
From the drop down select Formula Is
Enter this formula in the little box on the right:

=AND(COUNT(A1),A1=MAX($A1:$C1))

Click the Format button
Select the Patterns tab
Select a fill color
OK out

--
Biff
Microsoft Excel MVP


"richzip" wrote in message
...
I need help with conditional formatting. Basically I want to compare the
values in 3 cells, and have the special format apply to the highest value.
I
have 2 problems:

1. I found out how to do conditional formatting, and to set up multiple
conditions. But, it seems this is an "or" instead of an "and" function.
I
need the cell to be formatted if it meets both conditions (i.e. greater
than
the values in both cells it is being compared to)

2. When I go to conditional formatting, I can only change the font style.
Font size is "greyed out", and there is no option to highlight the cell a
specific color.