# Conditional Formatting

#### Sourav H

##### New Member
 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

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

#### Momentman

##### Well-known Member
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

##### Well-known Member
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

##### New Member
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...

Replies
3
Views
189
Replies
8
Views
255
Replies
7
Views
203
Replies
4
Views
240
Replies
6
Views
257

1,191,165
Messages
5,985,036
Members
439,935
Latest member
Monty238

### 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.

### Which adblocker are you using?

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

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