View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TxcPhtm TxcPhtm is offline
external usenet poster
 
Posts: 6
Default 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?