How to do conditional format in Excel based on condition in another column?
Most people use Excel conditional format only use the most basic option of conditional format. That is applying conditional formatting on the cell itself. What if you want to apply conditional format based on a condition of another column? For example, in the table below, if you want to highlight student names with grade A, you can use conditional format using formula. Watch this video to find out how.
Student name Grade Percentile
Noe Hakim A 80
Classie Memmott B 79
Kasey Kaler C 64
Brendon Kazee A 81
Abdul Krug B 76
Ronnie Martinelli E 55
Nicki Lange F 40
Michelina Gathers C 69
This is part of Practical Excel data analysis skills course. This courses build your skills in Excel so you will be confident applying the skills in just a few hours. https://www.udemy.com/practical-data-...