LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Greegan
 
Posts: n/a
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
More than 3 Conditional Formatting Conditions Beth H Excel Worksheet Functions 12 January 6th 06 07:35 PM
Conditional Formatting GoldDave Excel Discussion (Misc queries) 6 October 6th 05 02:53 PM
Conditional Formatting sweetsue516 Excel Discussion (Misc queries) 7 September 20th 05 08:16 PM
Formula Dependant Conditional Formatting LDanix Excel Discussion (Misc queries) 1 January 13th 05 06:50 PM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


All times are GMT +1. The time now is 08:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"