Color fill when date is entered

Hi

Alll you need is some conditional formatting.

click on the top left hand corner of excel to select all cells

Select the home tab and then conditional formats

Select New Rule

Select Use Formula to determine formatting

Enter this formula into the formula box =$I1>0

I think column I is your final date.

Select format

Select Fill

Select the colour you want.

Press Okuntil you get out of conditional formatting.

It is difficult to write good code based on a user's headers, although it can be done. It is better if you use column letter and row number references to define where your data resides. However, assuming that End Date is located in column "I", this event code would do what you want. To use the code, copy it to the worksheet code module of the sheet where the date would be entered by right clicking the sheet name tab, then select view code from the pop-up menu. When the code is installed, save the file as a macro enabled workbook and close the vb editor window. The code would then run when an entry is made into Column I.

Please Login or Register  to view this content.

BTW, you can upload a file to the forum share server by clicking the 'Go Advanced' button at the bottom of the reply box, then click 'Manage Attachments' and follow the menu.