Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can a spreadsheet be saved as interactive webpage | New Users to Excel | |||
How to make Excel More Interactive and Dynamic | Excel Discussion (Misc queries) | |||
Inserting an interactive spreadsheet into a webpage | Excel Discussion (Misc queries) | |||
how to make a workbook an interactive web page? | Excel Discussion (Misc queries) | |||
How do I make a spreadsheet interactive on a website? | Excel Discussion (Misc queries) |