Hello Pistol1,
Here is another Conditional Formatting option for you.
1) In a cell, say F1, type: =Countif($C$1:$C$50,"d")
2)Select C1 with mouse, go to “Format”, Conditional Formatting, with "Condition1" as "Formula is", type: =$F$1>0. Format color as desired (Don't think you can get transparent red in Conditional Formating though. Someone will correct me if i'm wrong)
3)Copy C1, drag down to C50, go to “Edit”, “Paste Special”, “Formats” , OK
The formula will scan C1:C50, looking for a "d". When the first "d" is entered, the formula will produce a value of "1". At this point the Conditional Formatting will have justification to highlight your specified range (C1:C50) to your specified color (Red).
HTH
Noir