Try this for your second condition:

=LEFT(D82,1)="C"

Hope this helps.

Pete