is there a way....

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

To have a column locate and color cells/cell entries based
on an input?
For example. Cells a-d have numbers. I input a number in
A1. Then Xecel finds and changes the text color on any it
finds of the same number in that column.
Thanks.
 
Have a look at VBA HELP index for FIND. There is a good example there.
 
Thank you.
Was unsure of ng to post in which is why the doubel post.
 
One other question. Have been searching help. Instead of
setting number for search is there a way for user input to
base search on?
 
You must log in or register to reply here.

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

Copying a formula to a range 2
Excel VBA 1
Fill color based on RGB 12
OFFSET LOOKUP function in VBA? 9
Format cells based on two conditions 4
Column number of last column that returns value ignore formulas 8
Count cells with content in different color background 2
Copying a Picture From Cell Comment 0

Back
Top