SOLVED

Excel Icon Help

Copper Contributor
Hi is there a way for my icons to recognised the task is complete?

 

When cell J is actioned 'complete' can this somehow removed the Icon in cell I?

 

Any help appreciated. 

 

Thanks, Porcha

 

Version: 2107

Porcha_0-1630968329792.png

 

2 Replies
best response confirmed by Porcha (Copper Contributor)
Solution

@Porcha 

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.

 

S0744.png

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
1 best response

Accepted Solutions
best response confirmed by Porcha (Copper Contributor)
Solution

@Porcha 

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.

 

S0744.png

View solution in original post