Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 74
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,355
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formats- paste special formats? jcarney Excel Discussion (Misc queries) 1 November 1st 07 07:37 PM
paste conditional formats as formats leo Excel Discussion (Misc queries) 2 July 5th 07 11:06 AM
Multiple Conditional formats Gunjani Excel Worksheet Functions 9 March 6th 07 02:27 AM
Apply multiple Conditional Formats Biocellguy Excel Worksheet Functions 1 July 25th 06 07:08 PM
how do i use multiple conditional formats in one cell? tysonstone Excel Discussion (Misc queries) 1 January 22nd 05 12:15 AM


All times are GMT +1. The time now is 05:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"