Conditional Formating soppose i make a table of student detail. i want to highlight name of student who scored >80% marks.

I'll hazard a guess at 15% are 80% or above. The one sigma point says 68% of the scores fall within 7% of the mean - 72%. Leaving 32% above or below 72+-7%. Split that and adjust a bit to arrive at 15%.

You and 11 others = 12. So the answer is twelve eightieths.

12 divided by 80 x 100 will give you the answer.

You can check the answer as 10% of 80 would be 8 students. For 10 percent you just move the decimal place one number to the left 80.0 = 8.00.

You can use Windows Excel
or
Adobe Open Office (free)

Select 'Spreadsheet' and away you go
The column width can be adjusted to suit the text
Text size is adjustable
Exam marks 1.2,3,4 etc can be auto calculated
Suggested format below (Open Office)
Name Fred Mary Jane



Roll 1 2 3



Exam 1 75 55 73



Exam2 80 81 82



Exam 3 66 71 90







Total 222 209 248

Conditional formating should be able to this. But how is your data organized? (Column headers, Row headers etc.)

50%

That is the crankshaft pulley cover with the ignition timing marks. To see details look here, p40-55

http://www.turboninjas.com/camry/eg2.pdf

did you put the sheet name in your reference? ex =Sheet2!A1 or you can name the cell ranges on the other sheets and use the cell names in your conditional formatting formla.

in Excel 2007 and if you have a cell (say C2) with the value of elapsed time (for example set = A2 which contains start time plus B2 which contains end time - or current time) - click in the cell (C2) then on the Home tab click on Styles >> Conditional formatting choose Highlight Cells Rules>>Greater Than... set your value in the dialog to your respective value and choose your highlight. This is a start - you can then add new rules.

to then apply this same conditional formatting to every cell in that column Ctrl-C to copy the cell you just formatted - then click on the column header to highlght the entire column - Right-click and choose Paste Special - then choose Formatting for what to paste.

It's slightly different in Excel 2003 so let us know what version you are using.

Cheers.

check this website, you will get all your answers there easily:
http://www.codeproject.com/
enjoy it!
Good luck

select n1.name,age,department from int newtable n1,n2 where n1.name=n2.name