In exel format what is the formula for find out

1. You can do it by-inserting a hyperlink and from the "insert hyperlink" window, select "place in this document" from the "Link to" pane. Then you can select desired destination sheet

2. First from unlock all cells from the format-protection menu.
then lock only those cells which you want to restrict access to the users.
then if you are using Office 2007, from the "review" tab select "protect sheet" then uncheck "Select locked cells" check box.
click ok then you are done.

1. Select all cells (either press Ctrl+A or click on the small upper left square on the edge of the worksheet)
2. In the menu bar, go to Format - Cells
3. In the popup menu that opens, click on the Protection tab (it should be the last one on the menu)
4. Deselect the small box tagged Locked
5. Click on OK. Now all your cells can be overwritten, regardless the protection status of the worksheet.
6. Select only the cells containing formulas that you want to hide (If you need to perform multiple selection, you can press and hold down the Ctrl key, while clicking on each cell you want to select)
7. In the menu bar, go to Format - Cells
8. In the popup menu that opens, click on the Protection tab
9. Tick the small box tagged Hidden and the Locked box as well. If you don’t tick the Locked box, other users of your worksheet would be able to overwrite the formula cells, without even knowing that they contain formulas (as they become invisible following this operation).
10. Click on OK
11. In the menu bar, go to Tools - Protection - Protect Sheet
12. If you want, you can input a password for unlocking the worksheet. This will prevent others from unlocking it. If you don’t want to do that, leave the password field blank and press OK.
13. Now click on one of your cells containing formulas and look at the formula bar. It should be empty, although the formula is still there. The cell would remain locked, but it would be automatically updated when changing the content of its precedents relating to the contained formula.

Use the IF and Date functions together. On sheet 3, put the birthday (3/15/1954) in cell B1, put the beginning date (1/1/1946) in cell C1 and the ending date (12/31/1964) in cell D1.
Then on Sheet 1, but the following formula in the cell you want an X to be placed in.
=IF(AND(Sheet3!B1>=Sheet3!C1,(Sheet3!B1<=Sheet3!D1)),"X"," ").
Make sure you type the formula Exactly as it appears.

here are some templates to get you started

http://office.microsoft.com/en-us/templates/CT101172771033.aspx

format the cells that contains times and net time worked as time format you using Enter the simple formula   =if(c14<=0,Int(0),(c14-c13))

You can use this formula
=IF(A2<=100,"Within budget","Over budget")
Which means
If the number above is less than or equal to 100, then the formula displays "Within budget". Otherwise, the function displays "Over budget" (Within budget)
or you and try something like this
=IF(A2=100,SUM(B5:B15),"")
which means
If the number above is 100, then the range B5:B15 is calculated. Otherwise, empty text ("") is returned ()
I got these examples from the help within Exel they give several more examples and more expaination.

select CONDITIONAL FORMATING in Format

select FORMULA IS , CELL VALUE = > < (condition)

after this select Format

font style , COLOR

SEE IT WILL WORK CHANGE OF COLOURS ........

Highlight the cells you want to format. Move the mouse to the highlighted area, press the right mouse button and make sure the locked option is on under the protection tab.

Make sure protect sheet is enabled. To activate it, press the review under the menu options and select protect sheet (if its on sheet) or workbook for more than one sheet.

You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (!) to the cell reference. In the following example, the AVERAGE worksheet function calculates the average value for the range C1:C10 on the worksheet named Marketing in the same workbook.

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively

1. Click the cell in which you want to enter the formula.
2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) , type = (equal sign).
3. Click the tab for the worksheet to be referenced.
4. Select the cell or range of cells to be referenced.

at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks