Find and show fill color

M

mulldoon

Can I make the cell or even better the row show a fill color only when the
cell or a cell in the row is selected?
I want to be able to use the find feature to do the selection and then show
the color.
Color would revert back to hidden once another cell was selected and the
new selection would show the same color.
 
R

Rick Rothstein

I'm not entirely sure I understand what you are trying to do. See if this
helps any and, if not, please clarify your question somewhat. When you do
your find operation, click the Find All button and then immediately after
that key in Ctrl+A... after doing that, all the found cells should be
selected. Is that what you were looking for?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Function for summing or counting cells based on a specified fill color 2
Run select query from VBA code where criteria comes from a multi select ListBox 2
Fill color 2
cell fill color not showing 1
Getting a fill color on a certain date 2
split cell diagonally and fill half with color 1
Excel VBA - counting cells by colors and names to it in two different rows. 0

Top