Question about Microsoft Office Standard for PC

1 Answer

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

Posted by on

  • avirane Sep 11, 2008

    I have 9 Column worksheet 1) Sr. No. , 2) Name, 3) Inv. No. 4)Inv. Dt., 5)Inv. Amt, 6)TDS Rate,7)TDS Amt, 8) Chq. No.,9)Chq. Dt.

    If I update chq. no. & Chq. dt. column the row should color.

    Kindly give me solution

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers

Use conditional formatting for the coloumn of student use Option " Formula Is" - In this write cell address of Marks e.g.c5 Then write =$c5>80 then click format and format the pattern

Posted on Oct 04, 2007

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

The mean score was 72%. The standard deviation was 7%. Based on this information, what is the best approximation for the number of students who scored 80% or better?


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%.

Mar 08, 2018 | Best Computers & Internet

2 Answers

There are 80 students in statistics . You and 11 others earned the same score, what percentage of the class received your score?


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.

Jan 17, 2016 | Office Equipment & Supplies

1 Answer

7. Program to manipulate N student details and sort the structures as per total marks obtained by them, by creating a structure to store the following details. Roll number, name, marks1, marks2, marks3


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

Mar 04, 2015 | Computers & Internet

2 Answers

How do I set up excel to change the background of a cell as the information within the call changes?


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

Oct 20, 2014 | Microsoft Excel for PC

1 Answer

Excel 2007: Conditional formatting


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.

May 08, 2009 | Microsoft Excel for PC

1 Answer

Conditional formating to highlight problems.


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.

Feb 27, 2009 | Microsoft Office Standard for PC

2 Answers

C code for student attendance record


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

Jan 30, 2009 | Computers & Internet

3 Answers

Sql Server 2005


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

Dec 10, 2007 | Microsoft SQL Server 2000 Standard Edition...

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

152 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2983 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...