Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting 2 criteria in one row
I would like to apply a conditional format in a row, where the first
condition is that the value be greater than the cell on the left AND equal to the one on the right. How do I get both conditions met using conditional formatting? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting 2 criteria in one row
Select cell (let's say B2)
Format- Conditional Format Choose "Formula is" Input the following: =AND(B2A2,B2=C2) Select format, click 'ok'. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "gimpy" wrote: I would like to apply a conditional format in a row, where the first condition is that the value be greater than the cell on the left AND equal to the one on the right. How do I get both conditions met using conditional formatting? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting 2 criteria in one row
Assuming you are trying to format B1
then use the option FORMULA IS and the formula as =AND(B1A1, B1=C1) and choose the format you want You can paint it over other cells in the row, except Col A. "gimpy" wrote: I would like to apply a conditional format in a row, where the first condition is that the value be greater than the cell on the left AND equal to the one on the right. How do I get both conditions met using conditional formatting? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting 2 criteria in one row
hi
formula is.....=and(b2A2,b2=c2).........pick your format. regards FSt1 "gimpy" wrote: I would like to apply a conditional format in a row, where the first condition is that the value be greater than the cell on the left AND equal to the one on the right. How do I get both conditions met using conditional formatting? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting of 4 criteria | Excel Discussion (Misc queries) | |||
CONDITIONAL FORMATTING FOR MORE THAN 3 CRITERIA | Excel Discussion (Misc queries) | |||
CONDITIONAL FORMATTING FOR MORE THAN 3 CRITERIA? | Excel Discussion (Misc queries) | |||
Conditional Formatting with more than 3 Criteria | Excel Discussion (Misc queries) | |||
Can I set more than three criteria for conditional formatting? | Excel Worksheet Functions |