Urgent!Conditional Formatting Highlighting

  • Thread starter Thread starter james blunt
  • Start date Start date
J

james blunt

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
 
Use this formula

=AND(OR(A1="USA",A1="England"),C1<10)

If this post helps click Yes
 
thank you for the help.
It works, however, is it possible to highlight the entire row
instead of highlighting A1 only?
 
thank you for the help.
It works, however, is it possible to highlight the entire row
instead of highlighting A1 only?
 
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.
 
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.
 
Back
Top