View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
merlin merlin is offline
external usenet poster
 
Posts: 27
Default 2 CONDITIONS FOR CONDITIONAL FORMAT?

I'm trying to format cells to a colour if they contain either an 'L' or an
'S'.

I've already used up my quota of three conditional formats so I need to
combine these into just one.

I've tried

="L" OR "S"

and

="L" OR = "S"

Am I on the wrong track or is this possible?