Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
How do I apply conditonally formatting to two rows which contain text? For
instance; A B 1 Australia Australia 2 New Zealand Canada 3 Canada New Zealand Is there anyway this is possible? Since row 2 shows that New Zealand is not matching to Canada as in the first row so it highlights New Zealand in a different color? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
What version of Excel are you using?
-- Biff Microsoft Excel MVP "LNS" wrote in message ... How do I apply conditonally formatting to two rows which contain text? For instance; A B 1 Australia Australia 2 New Zealand Canada 3 Canada New Zealand Is there anyway this is possible? Since row 2 shows that New Zealand is not matching to Canada as in the first row so it highlights New Zealand in a different color? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
2003
"T. Valko" wrote: What version of Excel are you using? -- Biff Microsoft Excel MVP "LNS" wrote in message ... How do I apply conditonally formatting to two rows which contain text? For instance; A B 1 Australia Australia 2 New Zealand Canada 3 Canada New Zealand Is there anyway this is possible? Since row 2 shows that New Zealand is not matching to Canada as in the first row so it highlights New Zealand in a different color? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Ok...
Let's assume you want to format the range A1:A10. Select the range A1:A10 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =A1<B1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "LNS" wrote in message ... 2003 "T. Valko" wrote: What version of Excel are you using? -- Biff Microsoft Excel MVP "LNS" wrote in message ... How do I apply conditonally formatting to two rows which contain text? For instance; A B 1 Australia Australia 2 New Zealand Canada 3 Canada New Zealand Is there anyway this is possible? Since row 2 shows that New Zealand is not matching to Canada as in the first row so it highlights New Zealand in a different color? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
which means that i can only apply conditional formatting to each cell, that
is one by one? is there any way where i can apply it to the whole range? "T. Valko" wrote: Ok... Let's assume you want to format the range A1:A10. Select the range A1:A10 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =A1<B1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "LNS" wrote in message ... 2003 "T. Valko" wrote: What version of Excel are you using? -- Biff Microsoft Excel MVP "LNS" wrote in message ... How do I apply conditonally formatting to two rows which contain text? For instance; A B 1 Australia Australia 2 New Zealand Canada 3 Canada New Zealand Is there anyway this is possible? Since row 2 shows that New Zealand is not matching to Canada as in the first row so it highlights New Zealand in a different color? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
If you followed my suggestion you are applying it to the whole range.
If you did follow my suggestion select cell A9. Goto the menu FormatConditional Formatting. Note the formula, it applies to cell A9. -- Biff Microsoft Excel MVP "LNS" wrote in message ... which means that i can only apply conditional formatting to each cell, that is one by one? is there any way where i can apply it to the whole range? "T. Valko" wrote: Ok... Let's assume you want to format the range A1:A10. Select the range A1:A10 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =A1<B1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "LNS" wrote in message ... 2003 "T. Valko" wrote: What version of Excel are you using? -- Biff Microsoft Excel MVP "LNS" wrote in message ... How do I apply conditonally formatting to two rows which contain text? For instance; A B 1 Australia Australia 2 New Zealand Canada 3 Canada New Zealand Is there anyway this is possible? Since row 2 shows that New Zealand is not matching to Canada as in the first row so it highlights New Zealand in a different color? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Yes, thanks it works.
"T. Valko" wrote: If you followed my suggestion you are applying it to the whole range. If you did follow my suggestion select cell A9. Goto the menu FormatConditional Formatting. Note the formula, it applies to cell A9. -- Biff Microsoft Excel MVP "LNS" wrote in message ... which means that i can only apply conditional formatting to each cell, that is one by one? is there any way where i can apply it to the whole range? "T. Valko" wrote: Ok... Let's assume you want to format the range A1:A10. Select the range A1:A10 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =A1<B1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "LNS" wrote in message ... 2003 "T. Valko" wrote: What version of Excel are you using? -- Biff Microsoft Excel MVP "LNS" wrote in message ... How do I apply conditonally formatting to two rows which contain text? For instance; A B 1 Australia Australia 2 New Zealand Canada 3 Canada New Zealand Is there anyway this is possible? Since row 2 shows that New Zealand is not matching to Canada as in the first row so it highlights New Zealand in a different color? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Good deal. Thanks for the feedback!
-- Biff Microsoft Excel MVP "LNS" wrote in message ... Yes, thanks it works. "T. Valko" wrote: If you followed my suggestion you are applying it to the whole range. If you did follow my suggestion select cell A9. Goto the menu FormatConditional Formatting. Note the formula, it applies to cell A9. -- Biff Microsoft Excel MVP "LNS" wrote in message ... which means that i can only apply conditional formatting to each cell, that is one by one? is there any way where i can apply it to the whole range? "T. Valko" wrote: Ok... Let's assume you want to format the range A1:A10. Select the range A1:A10 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =A1<B1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "LNS" wrote in message ... 2003 "T. Valko" wrote: What version of Excel are you using? -- Biff Microsoft Excel MVP "LNS" wrote in message ... How do I apply conditonally formatting to two rows which contain text? For instance; A B 1 Australia Australia 2 New Zealand Canada 3 Canada New Zealand Is there anyway this is possible? Since row 2 shows that New Zealand is not matching to Canada as in the first row so it highlights New Zealand in a different color? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Conditional Formatting Icon Sets | 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 |