Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting - Can I select a select with Conditional Formatting?
I have a menu button which is already assigned a macro. I want to add one
more step to the macro... Currently I have a Bingo Screen on my worksheet... B 1-15 I 16-30 N 31-45 G 46-60 O 61-75 These are all blacked out and will only change (conditional formatting) when a particular cell matches the number. My macro (in the menu I mentioned above) will change that highlighted cell (one that I currently need to select) and change it from green pattern with red font to a no fill pattern with black font, then generate the next number by doing some other things... I was wondering if its possible to have any cell which "lights up" with a red font and green pattern (which could appear anywhere in the numbers i have described above). If I could add such a command/script/vba (not sure of the proper name) then I would just need the one menu button to continue to the next bingo turn. Thanks for your assistance in advance. G |
#2
|
|||
|
|||
Conditional Formatting - Can I select a select with Conditional Formatting?
You might have missed my responses to your earlier post,
http://tinyurl.com/79cwl Take a look / try a play with the file provided: http://savefile.com/files/1978802 Random_Draw_without_Replacement_Program__Bingo_Boa rd_.xls Believe it fits what you were originally after .. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#3
|
|||
|
|||
Conditional Formatting - Can I select a select with Conditional Formatting?
Why didn't you make the grid where the numbers are "stored" symmetrical?
Biff "Max" wrote in message ... You might have missed my responses to your earlier post, http://tinyurl.com/79cwl Take a look / try a play with the file provided: http://savefile.com/files/1978802 Random_Draw_without_Replacement_Program__Bingo_Boa rd_.xls Believe it fits what you were originally after .. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#4
|
|||
|
|||
Conditional Formatting - Can I select a select with Conditional Formatting?
"Biff" wrote
Why didn't you make the grid where the numbers are "stored" symmetrical? If you meant the primary display panel where the numbers drawn will "light up", the set-up was done to the OP's specs. If you mean the top left grid where the drawn numbers are consecutively displayed in a zig-zag fashion, it's perhaps because I'm asymmetric <bg. Anyway, I've taken your point, Biff, and revised the top left grid to a symmetric 15 R x 5 C Revised* version at: http://www.savefile.com/files/5028169 Bingo_Board_v2_Random_Draw_without_Replacement.xls *Includes additional CF to "light up" the letters "B-I-N-G-O" in G18:G22 when the entire row of 15 numbers to the right of each letter are fully drawn [ via selecting G18:G22 (with G18 active), and using the formula: =SUMPRODUCT(COUNTIF(H18:V18,$G$2:$K$16))=15 ] -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#5
|
|||
|
|||
Conditional Formatting - Can I select a select with Conditional Formatting?
[ via selecting G18:G22 (with G18 active), and using the formula:
=SUMPRODUCT(COUNTIF(H18:V18,$G$2:$K$16))=15 ] Oops, just realized that the CF formula above, following normal COUNTIF syntax should actually be written as: =SUMPRODUCT(COUNTIF($G$2:$K$16,H18:V18))=15 But in this instance, think the earlier one works just as well (Thanks to symmetry!) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#6
|
|||
|
|||
Conditional Formatting - Can I select a select with Conditional Formatting?
=SUMPRODUCT(COUNTIF($G$2:$K$16,H18:V18))=15
Or, slightly shorter using SUM: =SUM(COUNTIF($G$2:$K$16,H18:V18))=15 -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |