View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default YACFQ - Yet Another Conditional Formatting Question...

Change the format condition to "Formua Is" rather than "Cell Value Is"
and enter this formula;

=AND(H150,H15<75)

You can still have the same red background format.

Hope this helps.

Pete