LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 75
Default How to make a more interactive spreadsheet?

Hello all. So here are 2 things I am trying to do.

I would like to make a worksheet function or process, that will change an
entire row green when 2 values in that row match. For instance K1 cell value
is 1 and R1 cell value is 1, the line would turn green, if it was a 0 in R1
then nothing would happen. Heres the catch though, I want that to happen in
real time. So when I type 1 and hit enter, the line would turn green.

Heres the second thing I want to do!
I would like to make some check boxes, that when checked will turn a line
red (or another color). I would also like to do this for several lines, maybe
200, once the macro is made for that, is there a way to attach it to its
specific cell, without having to retype a macro 200 times?

Thanks in advance
 
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
Can a spreadsheet be saved as interactive webpage El Plate New Users to Excel 3 July 15th 09 08:16 PM
How to make Excel More Interactive and Dynamic banker123 Excel Discussion (Misc queries) 1 December 11th 07 03:12 AM
Inserting an interactive spreadsheet into a webpage RichCo Excel Discussion (Misc queries) 0 November 19th 07 04:50 PM
how to make a workbook an interactive web page? DC Excel Discussion (Misc queries) 3 November 8th 05 09:40 PM
How do I make a spreadsheet interactive on a website? Regina Excel Discussion (Misc queries) 1 October 8th 05 04:53 AM


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

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"