| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
look up and color shading on numeric database?
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
look up and color shading on numeric database?
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
look up and color shading on numeric database?
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? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
look up and color shading on numeric database?
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? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
look up and color shading on numeric database?
I'm not following you. Why would you want to use find?
-- Biff Microsoft Excel MVP "ghinzrey" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count if a cell has color shading | Excel Discussion (Misc queries) | |||
| Auto color-shading of rows | Excel Worksheet Functions | |||
| Word Associated Shading or Color | Excel Worksheet Functions | |||
| Database text converted to numeric | Excel Discussion (Misc queries) | |||
| cell color shading | Excel Discussion (Misc queries) | |||
Linear Mode
