Conditional Formatting - Can I select a select with Conditional Formatting?

[Greegan]

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

 

[Max]

You might have missed my responses to your earlier post, re:
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_Board_.xls

Believe it fits what you were originally after ..

 

[Biff]

Why didn't you make the grid where the numbers are "stored" symmetrical?

Biff

 

[Max]

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 ]

 

[Max]

[ 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!)

 

[Max]

=SUMPRODUCT(COUNTIF($G$2:$K$16,H18:V18))=15

Or, slightly shorter using SUM:
=SUM(COUNTIF($G$2:$K$16,H18:V18))=15