Conditional Formatting

[Ranjan]

I want to format each cell in array A(i,j) conditioned on the comparison of
the value in row B(i) with a value in another array C(j), where the arrays B
and C are not part of the array A, that has to be formatted. Array B has the
same number of elements as the rows in A, and array C has the same number of
elements as the columns in A.

Can I do this by setting up a conditional formatting rule? Can I do this by
setting up the rule for A(1,1), and then dragging (or painting) the format to
rest of the array A?

 

[Shane Devenshire]

You can format cells in a range, you can't format cell in a VBA array. If
you are talking about ranges why not tell us what ranges and what conditons.

 

[Ranjan]

Shane

Thanks for the quick reply to the post. I will try to be more clear about
what I would like to do.

I would like to conditionally format (say, color red) each cell in array
(D1:Q11).

I would like to conditionally format each cell addressed by (JN) where J can
be any value in the range, D:Q, and N can be any value between 1:11, if the
content of cell (CN) in column C, is greater than the content of cell (J12)
in row 12.

The cell (CN) is from row in column C, that corresponds to the row of the
cell (JN) .

The cell (J12) is from column J in row 12, that corresponds to the column of
the cell (JN).

I can probably do this tediously, by defining a separate rule for each cell
, but that would be painful. Is there a good way to do this?

Thanks for you help