Home

Excel Help with Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-571950%22%20slang%3D%22en-US%22%3EExcel%20Help%20with%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-571950%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20know%20how%20to%20format%20a%20cell%20to%20add%20in%20a%20check%20mark%20by%20double%20clicking%20on%20the%20square.%26nbsp%3B%20I%20saw%20this%20in%20the%20%22Bill%20Paying%20Checklist%22%20template.%26nbsp%3B%20%3CSPAN%3EIt%20is%20in%20the%20%22Done%22%20column%20on%20the%20attached%20spreadsheet%20template.%26nbsp%3B%20I%20would%20like%20to%20create%20the%20exact%20same%20checkmark%20with%20the%20exact%20same%20feature%20of%20double%20clicking%20a%20cell.%26nbsp%3B%20%3C%2FSPAN%3EBecause%20it%20is%20a%20template%20it%20wont%20show%20you%20how%20they%20formatted%20the%20column%20to%20do%20this%20and%20it%20won't%20let%20you%20copy%20and%20paste%20to%20a%20different%20sheet%20so%20I%20need%20help%20learning%20how%20to%20do%20it%20on%20my%20own%20because%20I%20would%20like%20to%20use%20this%20feature%20on%20other%20Excel%20spreadsheets%20that%20I%20create.%26nbsp%3B%20I%20have%20attached%20a%20copy%20of%20the%20template%20so%20that%20you%20can%20see%20what%20I%20am%20looking%20to%20be%20able%20to%20do.%26nbsp%3B%20Thank%20you%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-571950%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-573052%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%20with%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-573052%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342767%22%20target%3D%22_blank%22%3E%40RanchersWife%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20is%20conditional%20formatting%20rule%20used%20here%20which%20shows%20the%20icon%20if%20cell%20value%20is%20greater%20than%20zero.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20734px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113704i515AFDF07EB03F06%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ewith%20Show%20Icon%20Only%20option%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20540px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113705i8146B0A99C821F6F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20you%20are%20not%20familiar%20with%20conditional%20formatting%20in%20general%20just%20google%20for%20that%2C%20lot%20of%20materials%20with%20samples%20are%20on%20web.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-576032%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%20with%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-576032%22%20slang%3D%22en-US%22%3E%3CP%3EI%20do%20not%20see%20the%20double-click%20behavior%20you%20describe%20in%20the%20template.%26nbsp%3B%20The%20conditional%20formatting%20is%20based%20on%20a%20number%20being%20entered%20in%20the%20spreadsheet%20in%20that%20cell%20where%20you%20want%20the%20check%20box%20displayed.%26nbsp%3B%20After%20a%201%20is%20entered%20the%20conditional%20formatting%20is%20applied.%26nbsp%3B%20I'd%20like%20to%20know%20a%20way%20to%20accomplish%20what%20you%20are%20seeking%20(without%20VBA)%2C%20but%20I%20don't%20think%20Excel%20enters%20anything%20ever%20just%20by%20double%20clicking%20a%20cell.%3C%2FP%3E%3CP%3EBTW%2C%20if%20you%20download%20the%20Excel%20Workbook%20and%20enable%20editing%2C%20you%20should%20be%20able%20to%20see%20and%20do%20whatever%20you%20want%20with%20the%20workbook.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342767%22%20target%3D%22_blank%22%3E%40RanchersWife%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
RanchersWife
Occasional Visitor

I want to know how to format a cell to add in a check mark by double clicking on the square.  I saw this in the "Bill Paying Checklist" template.  It is in the "Done" column on the attached spreadsheet template.  I would like to create the exact same checkmark with the exact same feature of double clicking a cell.  Because it is a template it wont show you how they formatted the column to do this and it won't let you copy and paste to a different sheet so I need help learning how to do it on my own because I would like to use this feature on other Excel spreadsheets that I create.  I have attached a copy of the template so that you can see what I am looking to be able to do.  Thank you for your help!

2 Replies

@RanchersWife ,

 

That is conditional formatting rule used here which shows the icon if cell value is greater than zero.

image.png

with Show Icon Only option

image.png

If you are not familiar with conditional formatting in general just google for that, lot of materials with samples are on web.

I do not see the double-click behavior you describe in the template.  The conditional formatting is based on a number being entered in the spreadsheet in that cell where you want the check box displayed.  After a 1 is entered the conditional formatting is applied.  I'd like to know a way to accomplish what you are seeking (without VBA), but I don't think Excel enters anything ever just by double clicking a cell.

BTW, if you download the Excel Workbook and enable editing, you should be able to see and do whatever you want with the workbook.@RanchersWife 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies