How to Create a Checklist using Conditional Formatting in Microsoft Excel

If you want to monitor your daily activities, you can create a To Do list which will be really helpful in completing the work.

We will use IF function in Conditional Formatting.

 

Let us take an example:

We have list of daily activities in column A & these are important or of more priority in column C.

In column B, we want checkmark whether the activity is important or not. We can enter a formula in conditional formatting to give a look of checkmark.
img1
 

  • In cell B2, the formula would be =IF(C2="Yes",1,0)
  • The above formula will give us either 1 or 0 depending on the selection in column C

img2
 
To apply conditional formatting:

  • Select the cells in which conditional formatting needs to be applied
  • Click on Home tab
  • From Styles group, click on Conditional Formatting
  • Select New Rule

img3
 

  • You can also use shortcut key ALT + O + D
  • The New Formatting Rule dialog box will appear

img4
 
Under Format Style:

  • Select Icon Sets

img5
 

  • Click on green Icon & select Green Check Symbol

img6
 

  • In Value field, enter 1 & change the Type to Number

img7
 

  • Now change the Yellow color ball to White Circle (All White Quarters)

img8
 

  • In Value field, enter 0 & change the Type to Number

img9
 

  • Change the third ball to No Cell Icon

img10
 

  • The last step is to check the Show Icon Only checkbox

img11
 

  • Click on OK button twice

img12
 
In this way, you can create your own To Do list using Conditional Formatting.

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 

 

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.