Greater Than Find/Replace
 

I'm trying to find all values within a range that are 0.50, when I enter
that information into the find field on Find/Replace, however, it doesn't
seem to recognize formulas, only text.

Is there anyway to find all the numbers 0.50, or enter a formula into the
find field, and then replace only those with a specific format?

Answer: Greater Than Find/Replace
 

1. Select the range of cells where you want to find the numbers greater than 0.50.
2. Press Ctrl + H to open the Find/Replace dialog box.
3. In the Find what field, enter "0.50" (without the quotes). This tells Excel to find all values greater than 0.50.
4. Leave the Replace with field blank.
5. Click on the Format button at the bottom of the dialog box and select the format you want to apply to the cells that meet the criteria. For example, you can choose to highlight the cells in yellow or bold the text.
6. Click on the Find All button to see a list of all the cells that meet the criteria.
7. If you're satisfied with the results, click on the Replace All button to apply the format to all the cells that meet the criteria.

Note that the Find/Replace feature in Excel only recognizes text, not formulas. However, you can use operators like , <, =, etc. to search for values that meet certain criteria.

Greater Than Find/Replace
 

If you want to apply formatting to cells 0.50, have you looked at using
either conditional formatting or a custom number format?

http://mcgimpsey.com/excel/conditional6.html

I'm not aware of Find/Replace being able to change formats (unless they
added it to XL2007). You could do it with VBA. Select the cells and try:

Sub Test()
Dim rngCell As Range

For Each rngCell In Selection.Cells
If rngCell.Value 0.5 Then
rngCell.NumberFormat = "0.00"
End If
Next rngCell

End Sub



"JG14" wrote:

I'm trying to find all values within a range that are 0.50, when I enter
that information into the find field on Find/Replace, however, it doesn't
seem to recognize formulas, only text.

Is there anyway to find all the numbers 0.50, or enter a formula into the
find field, and then replace only those with a specific format?

Greater Than Find/Replace
 

Have you tried doing it with Autofilter? You can apply a Custom
filter, choosing Greater Than or Equal To 0.5, and then just apply the
format to the visible cells. You could apply the format to one cell
and then use the Format Painter to apply the format to the other
visible cells.

Hope this helps.

Pete

On Jul 13, 10:54 pm, JG14 wrote:
I'm trying to find all values within a range that are 0.50, when I enter
that information into the find field on Find/Replace, however, it doesn't
seem to recognize formulas, only text.

Is there anyway to find all the numbers 0.50, or enter a formula into the
find field, and then replace only those with a specific format?

Greater Than Find/Replace
 

Hi,

You can use Advanced filter to extract all the values of a particular field
0.50, and then replace the Value with the Value you want.

Challa Prabhu

"JG14" wrote:

I'm trying to find all values within a range that are 0.50, when I enter
that information into the find field on Find/Replace, however, it doesn't
seem to recognize formulas, only text.

Is there anyway to find all the numbers 0.50, or enter a formula into the
find field, and then replace only those with a specific format?