Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 42
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 694
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you replace a yes value in a cell with a check mark? Flo Excel Discussion (Misc queries) 6 May 10th 23 07:46 PM
How can I add active tick mark/check mark boxes in excel? gerberelli Excel Discussion (Misc queries) 2 May 3rd 08 05:16 PM
Cannot check the check mark box in cell ac Excel Worksheet Functions 1 February 15th 08 10:24 PM
How do you replace a yes value in a cell with a check mark? Flo Excel Discussion (Misc queries) 0 June 26th 07 01:02 AM
How do I add a check mark in a cell in a spreadsheet in Excel? Carlos A. Excel Discussion (Misc queries) 9 July 6th 05 01:52 AM


All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"