Question 1 - Conditional Formatting. Place your cursor in Cell B1. Now
highlight the entire column. Select Format - Conditional Formatting -
Selection is Equal to and in the Formula box put = C1 + 10. change the
format to Bold and you are good to go...

Question 2 - Entering Dates. Check out this link...
http://www.cpearson.com/excel/DateTimeEntry.htm
--
HTH...

Jim Thomlinson


"ictime" wrote:

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.