In this Excel video tutorial, How to Use Conditional Formatting in Google Sheets based on a Criteria.

we can automatically highlight an entire row or a cell individually based on a criteria and the criteria can be a number or a text or also a formula

so let's say whenever you change the criteria the condition the entire row is going to be automatically highlighted for you

in this example I'm using a data set that is the sales report where I have information such as the date the order ID the products name the quantity sold and also the total sold

here I want to highlight the entire row and I'm going to use as criteria the total sold column whenever any value corresponds to the criteria that I choose the entire row is going to be automatically painted with a specific color

#JopaExcel #Dashboard #Excel