Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent!Conditional Formatting Highlighting
Is it possible to auto highlight WHOLE ROW when it's 3 or more criteria using
conditional formatting-highlight? eg: A B C D E F 1 USA 25 13 10 one M 2 England 40 10 19 one F 3 USA 40 2 20 two F 4 England 30 4 20 two M 5 Cuba 20 7 10 one M Criteria: USA or England , column C less than 10 If it can be done,How should i do it? thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent!Conditional Formatting Highlighting
Use this formula
=AND(OR(A1="USA",A1="England"),C1<10) If this post helps click Yes --------------- Jacob Skaria "james blunt" wrote: Is it possible to auto highlight WHOLE ROW when it's 3 or more criteria using conditional formatting-highlight? eg: A B C D E F 1 USA 25 13 10 one M 2 England 40 10 19 one F 3 USA 40 2 20 two F 4 England 30 4 20 two M 5 Cuba 20 7 10 one M Criteria: USA or England , column C less than 10 If it can be done,How should i do it? thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent!Conditional Formatting Highlighting
For help on Conditional Formatting refer
http://www.contextures.com/xlCondFormat02.html If this post helps click Yes --------------- Jacob Skaria "james blunt" wrote: Is it possible to auto highlight WHOLE ROW when it's 3 or more criteria using conditional formatting-highlight? eg: A B C D E F 1 USA 25 13 10 one M 2 England 40 10 19 one F 3 USA 40 2 20 two F 4 England 30 4 20 two M 5 Cuba 20 7 10 one M Criteria: USA or England , column C less than 10 If it can be done,How should i do it? thank you |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent!Conditional Formatting Highlighting
thank you for the help.
It works, however, is it possible to highlight the entire row instead of highlighting A1 only? "Jacob Skaria" wrote: Use this formula =AND(OR(A1="USA",A1="England"),C1<10) If this post helps click Yes --------------- Jacob Skaria "james blunt" wrote: Is it possible to auto highlight WHOLE ROW when it's 3 or more criteria using conditional formatting-highlight? eg: A B C D E F 1 USA 25 13 10 one M 2 England 40 10 19 one F 3 USA 40 2 20 two F 4 England 30 4 20 two M 5 Cuba 20 7 10 one M Criteria: USA or England , column C less than 10 If it can be done,How should i do it? thank you |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent!Conditional Formatting Highlighting
Select the *entire* range of interest starting from cell A1. A1 will be the
active cell. The active cell is the single cell in the selected range that *is not* shaded. The formula is relative and based on the active cell. =AND(OR($A1="USA",$A1="England"),$C1<10) The references will automatically adjust for the other cells in the applied range. -- Biff Microsoft Excel MVP "james blunt" wrote in message ... thank you for the help. It works, however, is it possible to highlight the entire row instead of highlighting A1 only? "Jacob Skaria" wrote: Use this formula =AND(OR(A1="USA",A1="England"),C1<10) If this post helps click Yes --------------- Jacob Skaria "james blunt" wrote: Is it possible to auto highlight WHOLE ROW when it's 3 or more criteria using conditional formatting-highlight? eg: A B C D E F 1 USA 25 13 10 one M 2 England 40 10 19 one F 3 USA 40 2 20 two F 4 England 30 4 20 two M 5 Cuba 20 7 10 one M Criteria: USA or England , column C less than 10 If it can be done,How should i do it? thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlighting the entire row with conditional formatting | Excel Worksheet Functions | |||
Highlighting using Conditional Formatting | Excel Worksheet Functions | |||
Highlighting a row with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting - Highlighting a row | Excel Worksheet Functions | |||
Highlighting text using conditional formatting | Excel Discussion (Misc queries) |