Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check Mark in a cell
I would like to have a check mark (or Word Art graphic) appear in a cell when
a value such as 1or x is entered in that cell (or similarly formatted cells). It would be great if i red 'X' if a wrong value is entered and a green check mark if a correct value is entered. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check Mark in a cell
Hi Wally
I'm not sure if this is what you want but anyway: First format with the font Marlett all the cells you want to have X or check marks, then type this in those cells =IF(C12="yes",CHAR(97),IF(C12="no",CHAR(114))) Change C12 for the cell that hold the answer. change "yes" for the proper answer and change "no" for the wrong answer. Now go to FormatConditional Formattingleave Cell Value is next box choose Equal to third box type : =CHAR(114) then press format and the tab Font change colour to red. Press the botton ADD same has above and third box type =Char(97) press format botton Font and choose green. Hope that will work for you John "Wally" wrote in message ... I would like to have a check mark (or Word Art graphic) appear in a cell when a value such as 1or x is entered in that cell (or similarly formatted cells). It would be great if i red 'X' if a wrong value is entered and a green check mark if a correct value is entered. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you replace a yes value in a cell with a check mark? | Excel Discussion (Misc queries) | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
Cannot check the check mark box in cell | Excel Worksheet Functions | |||
How do you replace a yes value in a cell with a check mark? | Excel Discussion (Misc queries) | |||
How do I add a check mark in a cell in a spreadsheet in Excel? | Excel Discussion (Misc queries) |