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