Conditonal Format
 

I have one cell which u can choose 3 options out on 1 of them being Done and
i want to make another cell respond to done by changing it to done aswell but
i want to be able to put a date in thereif the logical question is wrong e.g.
=IF($B$23="Done",$C$24="Done")
Whats wrong with this?

Conditonal Format
 

=IF($B$23="Done",$C$24="Done")
Whats wrong with this?

Based on your formula it looks like you want this to appear in C24.

Enter this formula in C24:

=IF($B$23="Done","Done",DATE(year,month,day))

Fill in the date parameters to suit. For example, for the date 7/4/2008:

=IF($B$23="Done","Done",DATE(2008,7,4))

--
Biff
Microsoft Excel MVP


"TxcPhtm" wrote in message
...
I have one cell which u can choose 3 options out on 1 of them being Done
and
i want to make another cell respond to done by changing it to done aswell
but
i want to be able to put a date in thereif the logical question is wrong
e.g.
=IF($B$23="Done",$C$24="Done")
Whats wrong with this?