View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
ghinzrey ghinzrey is offline
external usenet poster
 
Posts: 14
Default look up and color shading on numeric database?

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

"T. Valko" wrote:

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



--
Biff
Microsoft Excel MVP


"ghinzrey" wrote in message
...

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. Valko" wrote:

Need more detail.

Do any of your numbers have leading zeros?

Is this for a lottery?

--
Biff
Microsoft Excel MVP


"ghinzrey" wrote in message
...
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?