How would I go about making a cell change the text to equal D/O if the cell
is equal to "d". I can use conditional formatting to make the text white and
the fill purple but I can't get the formula to change the text from "d" to
D/O. Any ideas?

I currently have this furmula under the conditional formatting:

=IF(C4="d",1, 0)

Thanks