View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fred Fred is offline
external usenet poster
 
Posts: 59
Default Combine Conditional Formatting Rules formulae

I have 2 Conditional Formatting rules that result in ths same format
being applied to a cell, so would like to combine them to free up a
rule, however all my attempts have been unsuccessful.

Rule 1:
=AND(W60,W6<TODAY()-5,W6<TODAY(),D6<"Complete",D6<"Cancelled")
Rule 2: =OR(W6="Unknown",W6="Replanning")

Any suggestions gratefully received

Thanks and regards
Fred