look up and color shading on numeric database?

G

ghinzrey

Have a numeric database with three numerics each cell. I wish to look up
values, ex: 123 in any order and color shade cell. Can I?
 
T

T. Valko

Need more detail.

Do any of your numbers have leading zeros?

Is this for a lottery?
 
G

ghinzrey

Yes, I do have numbers leading zeros but not shown. If my data contains 003
means only 3 is seen.

Im sorry its not lottery but just numbers game.

Thanks.
 
T

T. Valko

Leading zeros in Excel are always a problem.

Excel doesn't "see" leading zeros as part of a numeric value. By default
Excel drops leading zeros but you can force it to *DISPLAY* them using a
custom format. However, this is for *display purposes only*. You may see the
leading zeros but to Excel they do not exist.

With that in mind...

You need to list all the combinations of the number of interest.

123
132
231
213
321
312

Assume these numbers are in the range G1:G6

The numbers you want to highlight are in the range A1:A10
Select the range A1:A10
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:

=MATCH(A1,G$1:G$6,0)

Click the Format button
Select the desired style(s)
OK out
 
G

ghinzrey

Thank you, at least made me getting started but sorry it doesn't work with
the "find" command. How do I?
 

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

Color shading on cells with same numeric content on three digit ce 1
Conditional Formating on three digit numeric cell database 4
Macros 1
slanted cell shading 8
VBA- Excel Programming:- 0
conditional format on first & last digit on 3 digit cell data 3
How to color font(numeral) on selected two digits from a 3digit ce 3
Comparison of columns using Conditional Formatting 3

Top