Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: urmein
- Order by date
-
Conditional Formatting Macro Issue
There exists an even simpler solution, if you don't require a contiguous data array (i.e., data in consecutive rows). My first formula assumes, and looks only at, a contiguous data array starting in cell C1. The OFFSET formula takes care of the dynamic change of the array length as you add new...- urmein
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Conditional Formatting Macro Issue
there is a simple solution to this problem (works at least on my MS Excel 2003 SP2 version). Assuming your data are in column C, then click on that column header. This activates the FULL column C. Add then the following formula to the Conditional Formatting (keyboard: Alt-o, d)...- urmein
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
