Comment Smart Conditional with airSlate SignNow

Comment smart conditional

another technique I often use is to use smart color coding in my tables so instead of highlighting the entire row I just put the color right beside my last number for Europe if I put 500 I get red if I put 650 I have green if I have 600 I'm close and within this threshold so I don't get any color there are different ways you can get to this I will show you one of the ways I generally use I'm going to copy this area let's go to a new sheet I'll paste that in as a first step I calculate my difference then I go to conditional formatting select new rules and now to show you another option I would say format only cells that contain the cell value in this case I want to keep my 15 absolute threshold so I would say is greater than 15 format the fill color that I want is green and I say okay let's see what happened I see green I see my number in there can week that number invisible I can highlight this area go to manage rules edit rule you can change what you're working on so in this case you see that's how it looked I can see my text the play number is black and I can see my green cell I go to format I can change my font to be the exact same green that I selected in my cell because then I can't see anything and to get a better effect that I don't have the green touching the surroundings of the cell I can say format and I add a white border I can add it here here here here okay now I have a little bit of a border so it doesn't stick to my other red ones so now it's the one for red is a conditional formatting I go to manage rules just to see my existing one add a new role again format only cells that contain now cell value is less than minus fifteen format this and start with fill I want it to be red but I don't want to see the black fund in my red for my font color I select the same red to get that border around white I don't want to see the ones that are within my treasure the ones that are going to be white I could add another conditional formatting as if it's between and make them white or I just make my default formatting to be a white font it's my default I'm going to make this really small or as small as I want minute looks like this and you see the white border makes them not stick together which is more visually appealing and obviously this is dynamic just like the way we saw it so 500 it's red 650 it's green that's how you can use smart coloring in your...