| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format based on criteria
I have a file where I want to use conditional format to tell whether this
student qualified for awards or not. Here is the example: A B C D Student Attendance score Math test score History test score Status Sam 8 70 50 Qualified Robsom 9 80 70 Melinda 5 65 70 The condition is: 5 for attendance score 60 for both Math & History test What I want to know is how to use conditional format to highlight the students based on the 3 conditions. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format based on other cells | Excel Discussion (Misc queries) | |||
| Conditional Format a row based on a cell? | Excel Worksheet Functions | |||
| filter or format based on criteria in more than one column | Excel Worksheet Functions | |||
| Conditional format based on entire row | Excel Worksheet Functions | |||
| conditional formula - based on 2 separate criteria | Excel Worksheet Functions | |||
Threaded Mode
