https://youtube.com/watch?v=ks_dvIvcS30Conditional Formatting is used to highlight interesting cells or ranges of cells, and visualize data by changing the appearance of cells based on specified conditions. There are many built-in conditions…