Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting and Entering Dates with out dashes
First thank you to everyone who has answered a question on this site. It has
been very helpful. Here are my issues. I have a worksheet with 5 columns of data. Column B has a formula that references column C. The formula looks like this =+C1+10. There are other formulas in this column but I am only concerned with this one. Anytime this occurs I want the cell to be bolded. I know to use conditional formatting and I figured out that I must use the cell is equal to section. But I don't remember how to write the formula so that it will mean Column C any Row + 10. Second issue involves entering dates. I would like to be able to type 11207 and have it appear in a cell as 01/12/2007. I found an add-on but we are no allowed to download items. Is there any other way to make this possible? Once again thank you for all your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting dates | Excel Discussion (Misc queries) | |||
conditional formatting when entering a date | Excel Worksheet Functions | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) |