I have certain cells in a worksheet that contain the word YES. I would like
to replace the word YES with a check mark.

try, Alt+0124

(numbers must be entered from the number keypad). Then change the font to
symbol.


"Flo" wrote:

I have certain cells in a worksheet that contain the word YES. I would like
to replace the word YES with a check mark.

hi,
another way...
Format cell to font Marlett. enter lower case a.

Regards
FSt1

"JMB" wrote:

try, Alt+0124

(numbers must be entered from the number keypad). Then change the font to
symbol.


"Flo" wrote:

I have certain cells in a worksheet that contain the word YES. I would like
to replace the word YES with a check mark.

Edit Replace Find what: yes Replace with: P Replace
Format cell as Wingdings 2

"Flo" wrote:

I have certain cells in a worksheet that contain the word YES. I would like
to replace the word YES with a check mark.

See

http://office.microsoft.com/en-us/ex...166011033.aspx

For several ways to do this. Some have been suggested by the other posters.

/Sune

"Flo" wrote:

I have certain cells in a worksheet that contain the word YES. I would like
to replace the word YES with a check mark.

Or, just for fun, use a macro:

Sub checkmark()
If ActiveCell.Value = "YES" Then
With ActiveCell
.Value = "ü"
.Characters(Start:=1, Length:=1).Font.Name = "Wingdings"
End With
End If
End Sub

You could add this to the worksheet code to make it automagic og just use a
shortcut.

/Sune

"Sune Fibaek" wrote:

See

http://office.microsoft.com/en-us/ex...166011033.aspx

For several ways to do this. Some have been suggested by the other posters.

/Sune

"Flo" wrote:

I have certain cells in a worksheet that contain the word YES. I would like
to replace the word YES with a check mark.

Sure, I can help you with that!

Here are the steps to replace the word "YES" with a check mark symbol in Microsoft Excel:

1. Select the cells that contain the word "YES" that you want to replace with a check mark.
2. Right-click on the selected cells and choose "Format Cells" from the context menu.
3. In the "Format Cells" dialog box, select the "Custom" category.
4. In the "Type" field, enter the following code:
   
   
   Formula:

   [Green]œ”;[Red]œ– 

   This code will display a green check mark symbol for any cell that contains the word "YES" and a red X symbol for any cell that does not contain the word "YES".
5. Click "OK" to apply the custom format to the selected cells.

That's it! Now any cell that contains the word "YES" will display a check mark symbol instead.