Forum Discussion
Excel Icon Help
Select the range in column I that you want to format.
I2 should be the active cell in the selection.
On the Home tab of the ribbon, select Conditional Formatting > Manage Rules...
Click 'New Rule...'
Select 'Use a formula to determine which cells to format'.
Enter the formula =J2="Complete"
Click OK without specifying a format.
The new rule should appear above the Icon Set rule.
Tick the check box 'Stop If True' for the new rule.
Click OK.
2 Replies
Select the range in column I that you want to format.
I2 should be the active cell in the selection.
On the Home tab of the ribbon, select Conditional Formatting > Manage Rules...
Click 'New Rule...'
Select 'Use a formula to determine which cells to format'.
Enter the formula =J2="Complete"
Click OK without specifying a format.
The new rule should appear above the Icon Set rule.
Tick the check box 'Stop If True' for the new rule.
Click OK.
- Thanks Hans I did eventually figure it out, for some reason when I selected those cells it put a $ in front of the 2 and it was what was preventing it to work, once I removed it, it worked great, Really appreciative of your response, to know I was on the right track. Ill defiantly remember to ask on the forum now. Cheers, Porcha
