Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
column A column b
active 01/01/09 sold 02/01/09 active 03/02/09 If A2="sold" I can get the the cell in B2 to change color but how do I get the date in column B to also change to "" at the same time? thanks for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
hi
formating cannot change data nor delete data. it can only change the way data looks on the sheet. so change the way the date looks by setting it's font color to the same color that you changed the cell to. Regards FSt1 "joe@malvern" wrote: column A column b active 01/01/09 sold 02/01/09 active 03/02/09 If A2="sold" I can get the the cell in B2 to change color but how do I get the date in column B to also change to "" at the same time? thanks for your help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
thanks for your help
"joe@malvern" wrote: column A column b active 01/01/09 sold 02/01/09 active 03/02/09 If A2="sold" I can get the the cell in B2 to change color but how do I get the date in column B to also change to "" at the same time? thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |