Excel Magic Trick 6 bangla (Part 2) - Conditional Formatting: Format all cells based on their values

This tutorial is for conditional formatting. Conditional Formatting (CF) is a tool that allows you to apply formats to a cell or range of cells and have that formatting change depending on the value of the cell or the value of a formula. In this tutorial we have discussed Format all cells based on their values. We have also discussed the sub category of conditional formatting. That’s are: 2-color scale, 3-color scale, data bar, icon sets. We have discussed the format type that are, Conditional formatting by percentile, Conditional formatting by percent, Conditional formatting by number, Conditional formatting by formula, Conditional formatting by lowest and highest value, Conditional formatting with data bar, Conditional formatting with icon sets In our discussion we have also discussed data bar, color scales different kinds of icon sets. I think it will be a good tutorial for excel learner and it will be helpful for all. Please, connect with me for the next part of this tutorial.

[hasinoorrahman]

অামিএকজন নতুন সদস্য। অাপনার অাপনার অালোচনা অামার খুব ভাল লাগে।

[hasinoorrahman]

পারভেজ ভাই কনডিশনাল ফরমেটের তৃতীয় পাট দেখান

[pravashmondal]

অামি একেবারে নতুন সদস্য। কলামের ঘর গুলো বড় করবো কিভাবে বলে দিলে খুবই উপকৃত বোধ করব