View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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?