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