Conditional Formatting

[Sourav H]

[TABLE="width: 340"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"] Highlight full row if score in any subject is greater than 35 and average greater than or equal to 60
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 340"]
<tbody>[TR]
[TD]Names
[/TD]
[TD]Sub 1
[/TD]
[TD]Sub 2
[/TD]
[TD]Sub 3
[/TD]
[TD]Average
[/TD]
[/TR]
[TR]
[TD]NM1
[/TD]
[TD="align: right"]20
[/TD]
[TD="align: right"]82
[/TD]
[TD="align: right"]42
[/TD]
[TD="align: right"]48
[/TD]
[/TR]
[TR]
[TD]NM2
[/TD]
[TD="align: right"]91
[/TD]
[TD="align: right"]85
[/TD]
[TD="align: right"]40
[/TD]
[TD="align: right"]72
[/TD]
[/TR]
[TR]
[TD]NM3
[/TD]
[TD="align: right"]85
[/TD]
[TD="align: right"]23
[/TD]
[TD="align: right"]60
[/TD]
[TD="align: right"]56
[/TD]
[/TR]
[TR]
[TD]NM4
[/TD]
[TD="align: right"]36
[/TD]
[TD="align: right"]41
[/TD]
[TD="align: right"]63
[/TD]
[TD="align: right"]46.66666667
[/TD]
[/TR]
[TR]
[TD]NM5
[/TD]
[TD="align: right"]100
[/TD]
[TD="align: right"]92
[/TD]
[TD="align: right"]81
[/TD]
[TD="align: right"]91
[/TD]
[/TR]
[TR]
[TD]NM6
[/TD]
[TD="align: right"]55
[/TD]
[TD="align: right"]64
[/TD]
[TD="align: right"]57
[/TD]
[TD="align: right"]58.66666667
[/TD]
[/TR]
[TR]
[TD]NM7
[/TD]
[TD="align: right"]68
[/TD]
[TD="align: right"]46
[/TD]
[TD="align: right"]93
[/TD]
[TD="align: right"]69
[/TD]
[/TR]
[TR]
[TD]NM8
[/TD]
[TD="align: right"]24
[/TD]
[TD="align: right"]27
[/TD]
[TD="align: right"]72
[/TD]
[TD="align: right"]41
[/TD]
[/TR]
[TR]
[TD]NM9
[/TD]
[TD="align: right"]25
[/TD]
[TD="align: right"]79
[/TD]
[TD="align: right"]44
[/TD]
[TD="align: right"]49.33333333
[/TD]
[/TR]
[TR]
[TD]NM10
[/TD]
[TD="align: right"]56
[/TD]
[TD="align: right"]56
[/TD]
[TD="align: right"]66
[/TD]
[TD="align: right"]59.33333333
[/TD]
[/TR]
[TR]
[TD]NM11
[/TD]
[TD="align: right"]66
[/TD]
[TD="align: right"]78
[/TD]
[TD="align: right"]26
[/TD]
[TD="align: right"]56.66666667
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Momentman]

Highlight cells A2 to E11 or the last row and use a formula like this in the conditional formatting

=AND(COUNTIF($B2:$D2,">35")>0,$E2>=60)

 

[Special-K99]

Assuming Names is in A1

Select a row

Conditional Formatting
New Rule
Use a formula to determine...

=(AND(COUNT(B2:D2) > 35),AVERAGE(B2:D2) > = 60))

format as required

Use Format painter (paintbrush icon) to copy to other cells

 

[Sourav H]

Assuming Names is in A1

Select a row

Conditional Formatting
New Rule
Use a formula to determine...

=(AND(COUNT(B2:D2) > 35),AVERAGE(B2:D2) > = 60))

format as required

Use Format painter (paintbrush icon) to copy to other cells

Thank u All...