LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
bioyyy
 
Posts: n/a
Default Flashing cell or row when condition is met,

Hi,
I need your help. I know you can help me with this-very smart. Ok, here is
the table:

Col: A B C D E
1 12 11 12 13
2 14 15 16 17
:
:
33 70 18 19 20

Let's see, whenever I type a number 1 in the G1, I like to see A1:E1
flashing (either text or background), or type #33 in G1, the whole row of
A33:E33 flash. In other words, whenever, the integer number in G1 matches
with any number in col A, the whole row is flahing for that match number in
col. A. I hope you get my question. Your help is greatly appreciated.

 
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
How to evoke a macro from a cell condition? Spooz Excel Discussion (Misc queries) 1 August 14th 05 05:15 PM
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
flashing cell Rob at BTAS Inc. New Users to Excel 7 February 6th 05 02:49 AM
sum of a cell if 2 cells meet a condition Markitos Excel Worksheet Functions 4 January 4th 05 05:27 PM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 01:01 PM


All times are GMT +1. The time now is 08:46 PM.

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

About Us

"It's about Microsoft Excel"