View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ring eye
 
Posts: n/a
Default conditional formatting with four conditions

Can it be done? I am trying to setup conditional formatting on the four
conditions.
value in cell M4 less than value in cell P4 color yellow
value in cell M4 greater than value in cell P4 color pink
value in cell M4 equal value in cell P4 Or Cell P4 equal
zero color purple

PS this is my second day on using Excel