| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wingdings 2. Check Mark (P).
Hello;
I set the Font into Wingdings 2, and put a formula =IF(G8="",,"P") This to put a check mark if Cell G8 is filled with any data, Now if there is any data in Cell G8, the check mark is appear, but the problem is if there no data a BOX is appear. How can I make EXCEL to put a check mark if the cell is filled with data, and remain empty if there no data. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Wingdings 2. Check Mark (P).
=IF(G8="","","P")
-- Regards Dave Hawley www.ozgrid.com "Khalid A. Al-Otaibi" wrote in message ... Hello; I set the Font into Wingdings 2, and put a formula =IF(G8="",,"P") This to put a check mark if Cell G8 is filled with any data, Now if there is any data in Cell G8, the check mark is appear, but the problem is if there no data a BOX is appear. How can I make EXCEL to put a check mark if the cell is filled with data, and remain empty if there no data. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make the check mark boc bigger on the check box? | Excel Discussion (Misc queries) | |||
| How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
| Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
| check box - allow only one check mark per category | Excel Discussion (Misc queries) | |||
| check box, so when you click on it it inserts a check mark into t. | Excel Discussion (Misc queries) | |||
Hybrid Mode
