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?

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?

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?

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?