Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple criteria
hi
I would like to know if there is a way I can evaluate 2 cells for conditional formatting. For example if the value in h2 is lower than cell a1 and higher than c1 make h2 purple otherwise make h2 red. I would like to know if this can be done using the conditional formatting menu item. If not I am welcome to other suggestions. Thanks in advance geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple criteria
First condition: use Formula Is
=AND(H2<A1,H2C1) and set the format Second condition: use Formula Is =OR(H2=A1,H2<=C1) and set the format best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "geebee" (noSPAMs) wrote in message ... hi I would like to know if there is a way I can evaluate 2 cells for conditional formatting. For example if the value in h2 is lower than cell a1 and higher than c1 make h2 purple otherwise make h2 red. I would like to know if this can be done using the conditional formatting menu item. If not I am welcome to other suggestions. Thanks in advance geebee |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple criteria
-- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. Put this conditional format on the cell. =AND(H2<A1,H2C1) "geebee" wrote: hi I would like to know if there is a way I can evaluate 2 cells for conditional formatting. For example if the value in h2 is lower than cell a1 and higher than c1 make h2 purple otherwise make h2 red. I would like to know if this can be done using the conditional formatting menu item. If not I am welcome to other suggestions. Thanks in advance geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIFS, one criteria range, multiple criteria | Excel Worksheet Functions | |||
match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |