View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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?