Excel Conditional formatting - New Rule 6 - Part 1- Use a formula to determine which cells to format
Table of Content:
Another Short Example: Mobile Screen
Sample Data for Practice
| Serial No | Name | Math Marks |
| 1 | Raj | 78 |
| 2 | Kumar | 56 |
| 3 | Rekha | 87 |
| 4 | Raju | 57 |
| 5 | Puja | 78 |
| 6 | Rahul | 81 |
| 7 | Roky | 88 |
| 8 | Adi | 22 |
| 9 | Abhy | 98 |
| 10 | Ramesh | 88 |
| 11 | Kailash | 25 |
| 12 | Ramu | 67 |
| 13 | Romesh | 68 |
| 14 | Rohit | 79 |