 Hey guys, welcome to SSQlitex, so see this site and this is continuation of PowerBate tutorial. So in this video, we'll see about the conditional formatting inside the web registrations. So go to on the PowerBate desktop and we'll see in the practical. In the last video, we have made the changes on the data colors. In usually like for US, you have selected this color and for Canada, for Australia. So we have made the changes like this, but we don't want to make changes as it has. So we want to make the changes like if US is having highest value, then it should be darker and in the decreasing order. For example, Germany is having the lowest, so it will be the lighter color. So how we can make this? So for that, we can select the column chart after that. Here we can see inside the data colors. You can get this data color, go to on the format and here you will see the option for data color. So in the default in the right side, you can see the three dots. You can click on that. After that, you can see the conditional formatting. So we can click on the conditional formatting. So we need to wait few seconds. Now here we can see it is counting the country name and according to that here it is the minimum value and here it is the highest value. So first of all, let me try to click on OK and we'll see. So here we can see US, then Canada, then Australia, but this is not as per our requirement. So how we can make the change? Again, go to on the conditional formatting and here instead of count of these country names, can you click on this? After that, go to on the country sales final table. Here we have the line total. So we can select that one and here on the basis of sum, we need to make the change. And also you can make the change on the color. For example, I wanna make darker. So now click on OK. After that you can see it is having the highest value, then the lowest, then lowest and in the decreasing order. So it is having the data colors as per our requirement. Now let me try to make the change one more time. And here instead of this color, we need to make this color. This might not be good. We can select that. Now we can click on OK. So now it looks good. Like this is the darker, then lighter, then lighter and Germany is having less value. So it is less darker. So I hope guys you have understand how we can change the data colors according to the conditions. So thank you so much guys for watching this video. If you like this video, please subscribe our channel to get many more videos.