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

You can use a select case statement an example of which can be found
here http://tinyurl.com/yah5lv8 If you need help specifically for your
application you will need to give us ranges, cell content example and
what formatting you need.


Papa Jonah;660510 Wrote:

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


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=184424

Microsoft Office Help