View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
John John is offline
external usenet poster
 
Posts: 48
Default conditional format problem

I have two conditions
1. m20
2. =M2-P2<3

It only pays attention to the 2nd condition. As if its and "or" rather
than an "and".

I'm using conditional formating off the toolbar.

I want to color the cell red if both conditions are met. It works fine
if m2 0 but it also works if m2=0. Why?

John