Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
|
|||
|
|||
Answer: Greater Than Find/Replace
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.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find minimum value greater than a particular value | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
find first value in a row with value greater than 0 | Excel Discussion (Misc queries) | |||
Find Min of a row, but only greater than zero? | Excel Worksheet Functions | |||
greater than replace numbers | Excel Worksheet Functions |