Urgent!Conditional Formatting Highlighting

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
 
J

Jacob Skaria

Use this formula

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

If this post helps click Yes
 
J

james blunt

thank you for the help.
It works, however, is it possible to highlight the entire row
instead of highlighting A1 only?
 
T

T. Valko

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top