Query related to Conditional Formatting

[Excel]

Hello Everyone, 

I have applied, SUBTOTAL command

like - 

.

I want to highlight Subtotal which is greater than zero with the help of Conditional Formatting ?

Please help...

Here is a attached file..

[#2 · Accepted solution]

@Excel 

Select A2:E51 if you want to highlight columns A to E, or E2:E51 if you just want to highlight column E

The active cell in the selection should be in row 2.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula

=AND(ISNUMBER(FIND("Total",$A2)),$E2>0)

Click Format...

Activate the Fill tab.

Select a color.

Click OK, then click OK again.

If you have a recent version of Excel, you can also use

=AND(ISNUMBER(FIND("SUBTOTAL",FORMULATEXT($E2))),$E2>0)

[#3]

Thank you so much sir.