All about conditional formatting based on another cell
Do you want to highlight some data in your Excel spreadsheets or differentiate some cells from others depending on the information shown in each one of them? Then conditional formatting is what you definitely need….