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

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers
Re: Conditional Formating

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

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

1 Answer

N student details and sort the stures as per total marks ,by creating a structure to store the roll number,name,marks1,marks2,marks3

You need to create a database with six fields: Roll Number, Name, Marks1, Marks 2, Marks 3 and MarksT (sum of marks1+2+3)

Sort database on MarksT in decending order.

Easily one in Excel - other programs will be similar

Mar 09, 2015 | The Business & Productivity Software

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 Conditional Formatting: how do I make one cell highlight based on whether or not another cell is blank?

option: formula is
formula: =(datecell="")
select formatting of choice

Highlight the order cells, go to >format>conditional formatting, choose "formula is" instead of "cell is". When you refer to the datecell, use the first date cell in the column only, and do not use $ signs.

Jan 09, 2013 | Microsoft Excel Business & Productivity...

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.


Feb 27, 2009 | Microsoft Office Standard for PC

1 Answer

Highlight weekend in the year planner

The easiest way of doing this is by inserting another row with Days
Can be MTWT etc, and you can set conditional formatting for any cell beginning with "S" into a colour/ variation of your choice.

Jan 03, 2009 | Microsoft Excel for PC

1 Answer

What are uses of vlookup n hlookup?

An implementation of the vlookup in Excel could be:
You have an Excel table with student names and their grades.
You wish that you could somewhere in the sheet type a student name, and immediately retrieve his grade (based on the data in the table).
To achieve this, you can use "Vlookup": the function will look for the student’s name in the first column in the table, and will retrieve the information that is next to his name in the second column (which is his grade).

Hlookup is the same excpet it is for data arranged by rows instead of columns.

Dec 29, 2008 | Microsoft Office Home and Student 2007...

1 Answer

Matching data

1. Open up both workbooks.
2. Copy one worksheet from one workbook to another using.
Right click on the tab of one book and Select "Move or Copy"
3. A dialog box will appear..Next to the "To book" select the workbook you want to move it to.
4. Be sure to select the 'create a copy' box in the bottom left of the dialog box.
5. Sort each worksheet by students name. Data..Sort.
6. Copy the scores from one sheet to another.
7. You then you can manipulate the scores and compare anyway you like by using formulas in different columns.

Apr 29, 2008 | Microsoft Excel for PC

3 Answers

Sql Server 2005

select,age,department from int newtable n1,n2 where

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

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

Related Topics:

135 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides