Insert the word live

Hi can anyone out there help , I am trying to get my spreadsheet to place the word live in one cell after I have date another cell so by dating a cell it makes the adjacent cell show the word live .

Regards Salardin

Suppose you put the date in D1 - you could have a formula like this:

=IF(D1="","","Live")

Hope this helps.

Pete

can you give the details what you want in excel sheet, then i can help you out. or else type the below wht you want after you typed.

Hi could you help me with this please if you look on the 2nd page it will explain

For the yellow area, highlight the cells A15:G24, then right-click and select Format Cells. Click on the Border tab, then unclick the middle vertical dividing line, then click OK.

For your orange area, I'm not sure what you want to do, but you could highlight the cells A27:G37, then right-click, then choose Format Cells | Border tab, and then click on the middle vertical and middle horizontal lines to fill them all in.

Hope this helps.

Pete

Hi again the yellow box I am trying to insert lines so it looks like a page in a note book
And the orange box so that is a series of coulombs

Name. Name. Name Name Name Name

Okay, for your orange area you need to unclick the middle horizontal lines and click the vertical lines.

Hope this helps.

Pete

Hi agaian Peter no it did not work think I am being to clever

Thanks

Is the attached what you mean?

Pete

Originally Posted by Pete_UK

Is the attached what you mean?

Pete

Yes Peter it is your brill how did you do it

Thank you but it is now sorted thanks