View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Rose
 
Posts: n/a
Default Conditional formatting formula

Sure, works like a charm. Why didn't I think of that?

"Pete_UK" wrote in message
oups.com...
Try this for your second condition:

=LEFT(D82,1)="C"

Hope this helps.

Pete