I'm interested in setting up a macro that will have similar functionality as
the Ctrl+F command. Except I need the macro to search the entire workbook
for any cells with white font. I'm guessing that this would not take too
much code to do, but I'm limited to macros I can record. Any help would be
appreciated.

Jeff

You do know you can use the Find command (Ctrl+F) to find the white text
cells, correct? Just click Options button to display the full Find dialog
box and click the Format button, then click the Font tab and pick the white
color from the Color dropdown, click OK and then click the Find All
button... you will get a listing of all the cells with white fonts.

If you know the above but still want a macro to do the same thing, tell us
what you want the macro to do with the found cells... list them somewhere,
change the Font color, something else.

--
Rick (MVP - Excel)


"goofy11" wrote in message
...
I'm interested in setting up a macro that will have similar functionality
as
the Ctrl+F command. Except I need the macro to search the entire workbook
for any cells with white font. I'm guessing that this would not take too
much code to do, but I'm limited to macros I can record. Any help would
be
appreciated.

Jeff

WOW! I have used Ctrl+F on an almost daily basis for years and the little
"Format" button on the right has completely gone unnoticed! This
accomplishes exactly what I need. Thank you!

"Rick Rothstein" wrote:

You do know you can use the Find command (Ctrl+F) to find the white text
cells, correct? Just click Options button to display the full Find dialog
box and click the Format button, then click the Font tab and pick the white
color from the Color dropdown, click OK and then click the Find All
button... you will get a listing of all the cells with white fonts.

If you know the above but still want a macro to do the same thing, tell us
what you want the macro to do with the found cells... list them somewhere,
change the Font color, something else.

--
Rick (MVP - Excel)


"goofy11" wrote in message
...
I'm interested in setting up a macro that will have similar functionality
as
the Ctrl+F command. Except I need the macro to search the entire workbook
for any cells with white font. I'm guessing that this would not take too
much code to do, but I'm limited to macros I can record. Any help would
be
appreciated.

Jeff