D
dkenebre
This is posted on the Misc. newsgroup as well.
I have simplified my explanation and updated my request from a previous
post on formatting: (See Chart for illustration.)
Okay, I have 3 sections to this chart, Number combination section,
double digits and boxed pairs.
The goal is to automate this chart whenever a 3 digit number is entered
into the spreadsheet it searches the double digit columns for a double
digit, if it applies then that double digit is highlighted YELLOW in
the double digit section, also another formula is used to search the
boxed pairs section for the 3 boxed pairs if the 3 digits do not have a
double digit, if it does then the formula will only search for the 2
boxed pairs in this section and in either case those cells are
highlighted RED.
Finally if the 3 digit numbers entered into the spreadsheet are all the
same digits (ie.7,7,7), then the double digit is highlighted BLACK,
with white font in the double digit section, instead of yellow. But if
it is simpler highlight the entire section on that row in black
highlight w/ white font, rather than only the double digit cell. Also,
the entire boxed pair section on this row is highlighted BLACK w/White
font.
File Attached: http://www.exceltip.com/forum/attachment.php?postid=271704 (achart question1.xls)
I have simplified my explanation and updated my request from a previous
post on formatting: (See Chart for illustration.)
Okay, I have 3 sections to this chart, Number combination section,
double digits and boxed pairs.
The goal is to automate this chart whenever a 3 digit number is entered
into the spreadsheet it searches the double digit columns for a double
digit, if it applies then that double digit is highlighted YELLOW in
the double digit section, also another formula is used to search the
boxed pairs section for the 3 boxed pairs if the 3 digits do not have a
double digit, if it does then the formula will only search for the 2
boxed pairs in this section and in either case those cells are
highlighted RED.
Finally if the 3 digit numbers entered into the spreadsheet are all the
same digits (ie.7,7,7), then the double digit is highlighted BLACK,
with white font in the double digit section, instead of yellow. But if
it is simpler highlight the entire section on that row in black
highlight w/ white font, rather than only the double digit cell. Also,
the entire boxed pair section on this row is highlighted BLACK w/White
font.
File Attached: http://www.exceltip.com/forum/attachment.php?postid=271704 (achart question1.xls)