Carbon Copy Autograph Conditional with airSlate SignNow

Carbon copy autograph conditional

Today's video is about Conditional Formatting in Excel. I'm going to show you how you can use formulas in Conditional Formatting and how you can conditionally format a range based on the value of another cell. So for example, conditionally format a row in Excel based on a sales value in that row? This way you can highlight a row or adjust the font color of a row based on another cell. It's going to be fun. Let's get to it. (upbeat music) In this example, I have lists of names and the yearly salary for each person. I want to format the values order rows if the salary is greater than or equal to the salary I type in here. So I'm going to do two different versions of this. In the first version, I just want to highlight the values, in the second version I want to highlight the rows where this condition is true because I'm adjusting the formatting based on a condition, I need to use Conditional Formatting. So first thing I need to do is highlight the range I want to format, go to Conditional Formatting and apply a new rule. I need to use a formula to determine which cells to format because the formatting of these cells is dependent on the value of another cell, and I can check that with a formula. I input the formula in here, Conditional Formatting is going to check whether the result of this formula is true or false. If it's true, it's going to apply to formatting that I define here, if it's false, it's going to leave the formatting as is. So it all comes down to the formula in here, so I'm going to start off with the equal sign. Now what type of formula do you write? Well here's the other rule when using Conditional Formatting, the formula that you type is always from the point of view of the first cell in the range that you've highlighted. This is from the point of view of B6 in this case. I want to check if this is greater than or equal to B3 here, notice as I'm doing the cell references here, Excel is automatically fully fixing the sign reference, is putting the dollar sign for both the column and the row. So is this going to work? Well let's try it. I'm going to apply the formatting that I want, once you go to Format, you can select between Number, Font Formatting, so you can adjust the font color or make the font bold or italic, you can adjust the border and the fill color. So in this case, I'm just going to go with the fill color and click on OK. That was my formula, right? Actually I'm just going to copy it as well and click on OK. Nothing happens, why? Because B6 is not greater than 80,000. If I change this to 80,000 or 81,000, because my formula was...