D
dkenebre
If you have viewed and/or posted to this post on excel misc., please
disregard, otherwise, I would appreciate your help.
I am needing to automate these conditions. See chart for example, if
necessary. Thank you.
First
Whenever, a 3 digit numeric combination is entered into B, C and D
cells and if each of the 3 digits are different (ie.3,7,2), then find
the 3 cells on the same row between O and BG that have the
corresponding boxed the 2 digit pairs. (O=01, P=02, Q=03, R=04, S=05,
T=06, U=07, V=08, W=09, X=12, Y=13, Z=14, AA=15, AB=16, AC=17, AD=18,
AE=19, AF=23, AG=24, AH=25, AI=26, AJ=27, AK=28, AL=29, AM=34, AN=35,
AO=36, AP=37, AQ=38, AR=39, AS=45, AT=46, AU=47, AV=48, AW=49, AX=56,
AY=57, AZ=58, BA=59, BB=67, BC=68, BD=69, BE=78, BF=79, BG=89) and
highlight the 3 cells RED, then all of the previous cells in each of
those 3 columns that is not highlighted RED or BLACK will automatically
be highlighted blue.
Example A: 4,1,9 (z=14, AE=19 and AW=49 get highlighted RED, all the
previous cells in these 3 columns which are highlighted white are
changed to blue)
Second
Whenever a 3 digit numeric combination is entered into B, C and D cells
and if 2 of 3 the digits are the same (ie. 3,7,7), then find the one
cell on the same row between O and BG that has the corresponding boxed
2 digit pair, then highlight that cell RED and then all of the previous
cells in that column that is not highlighted RED or BLACK will
automatically be highlighted blue.
Example B: 4,2,2 (AG=24 get highlighted RED, all the previous cells in
this column which are highlighted white are changed to blue)
Third
Whenever a 3 digit numeric combination is entered into B, C and D cells
and all 3 the digits are the same (ie. 7,7,7), then find the cells on
the same row between O and BG and automatically highlight those cells
BLACK and text white, and then all of the previous cells in each column
that is not highlighted RED or BLACK will automatically be highlighted
blue.
Example C: 5,5,5 (All cells on the same row O through BG are highlight
BLACK with white font and all previous cells in each column which are
highlighted white are changed to blue)
If necessary, see sample chart in the Attachment
File Attached: http://www.exceltip.com/forum/attachment.php?postid=269872 (achart question1b.xls)
disregard, otherwise, I would appreciate your help.
I am needing to automate these conditions. See chart for example, if
necessary. Thank you.
First
Whenever, a 3 digit numeric combination is entered into B, C and D
cells and if each of the 3 digits are different (ie.3,7,2), then find
the 3 cells on the same row between O and BG that have the
corresponding boxed the 2 digit pairs. (O=01, P=02, Q=03, R=04, S=05,
T=06, U=07, V=08, W=09, X=12, Y=13, Z=14, AA=15, AB=16, AC=17, AD=18,
AE=19, AF=23, AG=24, AH=25, AI=26, AJ=27, AK=28, AL=29, AM=34, AN=35,
AO=36, AP=37, AQ=38, AR=39, AS=45, AT=46, AU=47, AV=48, AW=49, AX=56,
AY=57, AZ=58, BA=59, BB=67, BC=68, BD=69, BE=78, BF=79, BG=89) and
highlight the 3 cells RED, then all of the previous cells in each of
those 3 columns that is not highlighted RED or BLACK will automatically
be highlighted blue.
Example A: 4,1,9 (z=14, AE=19 and AW=49 get highlighted RED, all the
previous cells in these 3 columns which are highlighted white are
changed to blue)
Second
Whenever a 3 digit numeric combination is entered into B, C and D cells
and if 2 of 3 the digits are the same (ie. 3,7,7), then find the one
cell on the same row between O and BG that has the corresponding boxed
2 digit pair, then highlight that cell RED and then all of the previous
cells in that column that is not highlighted RED or BLACK will
automatically be highlighted blue.
Example B: 4,2,2 (AG=24 get highlighted RED, all the previous cells in
this column which are highlighted white are changed to blue)
Third
Whenever a 3 digit numeric combination is entered into B, C and D cells
and all 3 the digits are the same (ie. 7,7,7), then find the cells on
the same row between O and BG and automatically highlight those cells
BLACK and text white, and then all of the previous cells in each column
that is not highlighted RED or BLACK will automatically be highlighted
blue.
Example C: 5,5,5 (All cells on the same row O through BG are highlight
BLACK with white font and all previous cells in each column which are
highlighted white are changed to blue)
If necessary, see sample chart in the Attachment
File Attached: http://www.exceltip.com/forum/attachment.php?postid=269872 (achart question1b.xls)