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?
|