Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Ranjan" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
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 "Shane Devenshire" wrote: 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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Ranjan" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |