Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format
I have three 10x10 tables and each have different values for the same item.
So all in all, there are 100 items with three values each. So for example, the item in in the first column, first row of table one is the same as the item in the first column, first row of table 2 and table 3. If the value of item 1 is 3 in table 1, 2.5 in table 2, and 3.5 in table 3, how can I create a rule that will highlight all of them if each value is greater than 2? So to clarify, if the value in table 1 is 1.5, I don't want any of the values in tables 1, 2, or 3, to highlight for item 1. In other words, I want each item with all three values greater than 2 to be highlighted. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format
Assuming the tables are A1:J10, M1:V10, and AA1:AJ10, then select all 300
cells, A1:J10 last, and use a formula in CF of =AND(A12,M12,AA12) and format. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Conditional Format Issue" m wrote in message ... I have three 10x10 tables and each have different values for the same item. So all in all, there are 100 items with three values each. So for example, the item in in the first column, first row of table one is the same as the item in the first column, first row of table 2 and table 3. If the value of item 1 is 3 in table 1, 2.5 in table 2, and 3.5 in table 3, how can I create a rule that will highlight all of them if each value is greater than 2? So to clarify, if the value in table 1 is 1.5, I don't want any of the values in tables 1, 2, or 3, to highlight for item 1. In other words, I want each item with all three values greater than 2 to be highlighted. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format
When I select all three tables, it only applies the formatting to the last
one - is there any way to work around this? I can select each table individually, but I need to repeat this process multiple times and that would be a nuisance. Another workaround would be to copy-paste conditional formatting - is that possible? "Bob Phillips" wrote: Assuming the tables are A1:J10, M1:V10, and AA1:AJ10, then select all 300 cells, A1:J10 last, and use a formula in CF of =AND(A12,M12,AA12) and format. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Conditional Format Issue" m wrote in message ... I have three 10x10 tables and each have different values for the same item. So all in all, there are 100 items with three values each. So for example, the item in in the first column, first row of table one is the same as the item in the first column, first row of table 2 and table 3. If the value of item 1 is 3 in table 1, 2.5 in table 2, and 3.5 in table 3, how can I create a rule that will highlight all of them if each value is greater than 2? So to clarify, if the value in table 1 is 1.5, I don't want any of the values in tables 1, 2, or 3, to highlight for item 1. In other words, I want each item with all three values greater than 2 to be highlighted. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format
If you select one range, then Ctrl-Select another, then Ctrl-Select the
third, the third being A1:J10, that should work. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Conditional Format Issue" m wrote in message ... When I select all three tables, it only applies the formatting to the last one - is there any way to work around this? I can select each table individually, but I need to repeat this process multiple times and that would be a nuisance. Another workaround would be to copy-paste conditional formatting - is that possible? "Bob Phillips" wrote: Assuming the tables are A1:J10, M1:V10, and AA1:AJ10, then select all 300 cells, A1:J10 last, and use a formula in CF of =AND(A12,M12,AA12) and format. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Conditional Format Issue" m wrote in message ... I have three 10x10 tables and each have different values for the same item. So all in all, there are 100 items with three values each. So for example, the item in in the first column, first row of table one is the same as the item in the first column, first row of table 2 and table 3. If the value of item 1 is 3 in table 1, 2.5 in table 2, and 3.5 in table 3, how can I create a rule that will highlight all of them if each value is greater than 2? So to clarify, if the value in table 1 is 1.5, I don't want any of the values in tables 1, 2, or 3, to highlight for item 1. In other words, I want each item with all three values greater than 2 to be highlighted. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |