Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text in a cell invoke constant date in another cell - how
To save effort I want the current (konstant) date to be inserted in a cell
when text is inserted in another cell. Hov to colorize a cell by conditional formate depending on the content of the adjacant cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text in a cell invoke constant date in another cell - how
Frode,
The formula for the cell in which you want the current date to be inserted is: =IF(A1="","",NOW()) You will need to format the result to be a DATE format. Choose FormatCells, and then choose DATE. Select the DATE format option that you want to apply. Conditional Formatting will allow you to achieve cell colors, text colors, and other cell formating options based on a value in an adjacent cell. 1) Select the cell to which you want to apply conditional formating; 2) Choose FormatConditional Formating. The conditional formating dialogue box will appear. 3) In the 1st drop down list, select "Cell Value Is", then 4) In the 2nd drop down list, select "not equal to", then 4) In the 3rd drop down list, enter ="""""", then 5) click on the Format button. The Format Cells dialogue box will appear. 6) Click on the Patters tab, and select the color you want to apply. Click OK to close the Format Cells dialogue box. Then Click on OK in the Conditional Formating dialogue box to close that box. Let me know if this resolves your questions. Hope this does the trick for you. Best Wishes, Mike "Frode Inge Helland" wrote: To save effort I want the current (konstant) date to be inserted in a cell when text is inserted in another cell. Hov to colorize a cell by conditional formate depending on the content of the adjacant cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set text color based on value in cell compared to constant | Excel Discussion (Misc queries) | |||
Display constant cell value based on another cell value | Excel Worksheet Functions | |||
How can I convert a text cell into date cell in Excel | Excel Discussion (Misc queries) | |||
Cell colors or text color changing when date in cell gets closer. | Excel Worksheet Functions | |||
How do you convert a formula cell to a constant cell | Excel Discussion (Misc queries) |