Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA code to "background-color" a cell obtaining a value from Row
2003
What syntax can I add to a an If() statement to test if a cell is receiving input (referenced to) from any cells below it? (In violation of the best-practice of top-down worksheet organization) I get the concept that Cell(2,1) which is referred to Cell(1,1) would be an example. But what is the best surrounding syntax to make sure that my test is accurate? Thanks EagleOne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA code to "background-color" a cell obtaining a value from Row
Got it!
If MyCell.DirectPrecedents.Row MyCell.Row Then MyCell.Interior.ColorIndex = 3 Any other thoughts? EagleOne wrote: 2003 What syntax can I add to a an If() statement to test if a cell is receiving input (referenced to) from any cells below it? (In violation of the best-practice of top-down worksheet organization) I get the concept that Cell(2,1) which is referred to Cell(1,1) would be an example. But what is the best surrounding syntax to make sure that my test is accurate? Thanks EagleOne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Obtaining & using last cell in a column in a cell formula | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Code to an in cell drop down list | Excel Discussion (Misc queries) | |||
Find the cell value in excel by using vb code | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |