View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pat999 Pat999 is offline
external usenet poster
 
Posts: 3
Default Conditional Formatting

I want to color a cell based on the value of that cell being greater than
zero and another cell not being equal to "x".

I've used conditional formatting with "formula is" and formula -
IF(A10,B1<"X")

This does not seem to work - what am I doing wrong??????