Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Highlighting
I would like to enter a series of values in a horizontal range of cells. Then
I would like the numbers array (about 20rows x 40col) that match the input to highlight themselves. Thanks in advance Phil |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Highlighting
Assume your horiz range of values are within A1:D1,
and your 20R x 40C range is within A3:AN22 Select A3:AN22 (with A3 active), then apply conditional formatting using Formula is: =COUNTIF($A$1:$D$1,A3) Format to taste, OK out. Adapt to suit -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "PEGWINN" wrote: I would like to enter a series of values in a horizontal range of cells. Then I would like the numbers array (about 20rows x 40col) that match the input to highlight themselves. Thanks in advance Phil |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Highlighting
What version of Excel are you using? This will work in versions prior to
Excel 2007. Assume the input range is A1:E1 The table range is A5:E10 Select the range A5:E10 with A5 being the active cell. The active cell is the one that doesn't have a blueish color. Goto the menu FormatConditional Formatting Formula Is: =AND(A5<"",OR(A5=$A$1:$E$1)) Click the Format button Select the Patterns tab Selet a fill color of your choice OK out -- Biff Microsoft Excel MVP "PEGWINN" wrote in message ... I would like to enter a series of values in a horizontal range of cells. Then I would like the numbers array (about 20rows x 40col) that match the input to highlight themselves. Thanks in advance Phil |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Highlighting
Max and T,
Thanks, I will try it tomorrow night and let you know how it went. Phil |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Highlighting
Ok, it took a little more than "tomorrow" but I got it done using both
methods. Thanks a lots guys it was perfect. -- Phil "PEGWINN" wrote: Max and T, Thanks, I will try it tomorrow night and let you know how it went. Phil |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Highlighting
Good to hear that. Thanks for feeding back.
btw, I threw in some thoughts on your other posting: Randomize from a list -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "PEGWINN" wrote in message ... Ok, it took a little more than "tomorrow" but I got it done using both methods. Thanks a lots guys it was perfect. -- Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
variable height variable width stacked bar charts | Charts and Charting in Excel | |||
variable in a link where the variable is the name of the sheet | Excel Worksheet Functions | |||
Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions |