Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formats- paste special formats? | Excel Discussion (Misc queries) | |||
paste conditional formats as formats | Excel Discussion (Misc queries) | |||
Multiple Conditional formats | Excel Worksheet Functions | |||
Apply multiple Conditional Formats | Excel Worksheet Functions | |||
how do i use multiple conditional formats in one cell? | Excel Discussion (Misc queries) |