Conditional format (word change)
 

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

Perhaps CF is not the way to go!
Can someone help me with a formula to put 'Closed' in
Column C when AC date is entered and AD=N. Also when AC
date is entered, AD=Y and AE date is entered? I can leave
Column C blank.

Thanks

-----Original Message-----
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

.

=IF(AND(ISNUMBER(AC3),AD="N",ISNUMBER(AE)),"Open", "Closed")
is getting me close, not sure how to finish it!
TIA
-----Original Message-----
Perhaps CF is not the way to go!
Can someone help me with a formula to put 'Closed' in
Column C when AC date is entered and AD=N. Also when AC
date is entered, AD=Y and AE date is entered? I can leave
Column C blank.

Thanks

-----Original Message-----
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

.

.