Forum Discussion

Copper Contributor

Sep 06, 2021

Solved

Excel Icon Help

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

excel

Formulas and Functions

office 365

HansVogelaar
Sep 07, 2021
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.

HansVogelaar

MVP

Sep 07, 2021

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.

Porcha

Copper Contributor

Sep 07, 2021

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