conditional formatting
in [Programming]
|
From: Papa Jonah on 3 Mar 2010 18:36 I want to establish conditional formatting of cells in one column based on content in a neighboring cell. The formatting options are going have about six options which mean I need to use VBA instead of the conditional formatting function directly in the worksheet. My question is once I establish the syntax to describe the formatting (the nested if then statements) is there an easier way to put this in the code rather than having a for x= 1 to 1000 next x loop to go through each row? TIA Papa Jonah
|
Pages: 1 Prev: Copy Data From Varying Lines to One Sheet Next: Worksheet_Calculate |