I would like to add a second Conditional format to just
Column C (specifically C3 to C2000)to change the word Open
to Closed based on this criteria:
=OR(AND(ISNUMBER($AC3),$AD3="N"),AND(ISNUMBER
($AE3),ISNUMBER($AC3),$AD3="Y"))
which is used to change the color of the entire row
through Conditional formatting.

AC is a date Column
AD contains Y or N
AE is a date Column

Working examples:
1) If AC has a date and AD has a Y then AE needs a date to
make C3 = Closed, otherwise C3 stays as Open.
2) If AC has a date and AD has a N then C3 Open goes to
Closed.
('Open' is always in Column C by default)

I cannot get my Column C to change and any help would be
appreciated!

TIA