Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching specifc dates using Conditonal format | Excel Worksheet Functions | |||
Conditonal Format Problem | Excel Discussion (Misc queries) | |||
Pivot Table Conditonal Format of the Grand Total | Excel Worksheet Functions | |||
Conditonal Format Formula | Excel Worksheet Functions | |||
Conditonal Format with a date format | Excel Discussion (Misc queries) |