Multiple conditional formats

[richzip]

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.

 

[Barb Reinhardt]

I'd try

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

To highlight the cell, use the PATTERNS tab.

 

[T. Valko]

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 Format>Conditional 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 Format>Conditional 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