If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|