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

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

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

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

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