Forum Discussion
Solved
Query related to Conditional Formatting
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..
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)
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)
- Thank you so much sir.
