Conditional Formatting

Sourav H

New Member
Joined
Sep 10, 2014
Messages
7
Highlight full row if score in any subject is greater than 35 and average greater than or equal to 60

<tbody>
</tbody>

Names
Sub 1
Sub 2
Sub 3
Average
NM1
20
82
42
48
NM2
91
85
40
72
NM3
85
23
60
56
NM4
36
41
63
46.66666667
NM5
100
92
81
91
NM6
55
64
57
58.66666667
NM7
68
46
93
69
NM8
24
27
72
41
NM9
25
79
44
49.33333333
NM10
56
56
66
59.33333333
NM11
66
78
26
56.66666667

<tbody>
</tbody>
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
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)
 
Upvote 0
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
 
Upvote 0
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...
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,114,002
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top