ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I create a checklist that changes color as items are checked? (https://www.excelbanter.com/excel-discussion-misc-queries/146915-can-i-create-checklist-changes-color-items-checked.html)

The Waco Kid

Can I create a checklist that changes color as items are checked?
 
How would I do so? Is it possible in other appications?

Mike H

Can I create a checklist that changes color as items are checked?
 
It depends on how you put your checkmark in.

Put a checkmark in by selecting start:run|Charmap

Select wingdings font and copy the checkmark to the clipboard.
Paste it in Excel and use the pasted checkmark every time you want one.
For it to show as a checkmark your cell must be formatted with Wingding font

then in A1 use the conditional format

=B1=CHAR(252)

Drag down as required and when you paste a checkmark in Col B, Col A turns
whatever colour you chose.

Mike

"The Waco Kid" wrote:

How would I do so? Is it possible in other appications?



All times are GMT +1. The time now is 12:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com