View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
james blunt james blunt is offline
external usenet poster
 
Posts: 1
Default 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