conditional formatting 2 criteria in one row

[gimpy]

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?

 

[Luke M]

Select cell (let's say B2)
Format- Conditional Format
Choose "Formula is"
Input the following:
=AND(B2>A2,B2=C2)
Select format, click 'ok'.

 

[Sheeloo]

Assuming you are trying to format B1
then use the option FORMULA IS and the formula as
=AND(B1>A1, B1=C1)
and choose the format you want

You can paint it over other cells in the row, except Col A.

 

[FSt1]

hi
formula is.....=and(b2>A2,b2=c2).........pick your format.

regards
FSt1