SOLVED

Excel Icon Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2726313%22%20slang%3D%22en-US%22%3EExcel%20Icon%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2726313%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-message-subject-wrapper%20lia-component-subject%20lia-component-message-view-widget-subject-with-options%22%3E%3CSPAN%3EHi%20is%20there%20a%20way%20for%20my%20icons%20to%20recognised%20the%20task%20is%20complete%3F%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20cell%20J%20is%20actioned%20'complete'%20can%20this%20somehow%20removed%20the%20Icon%20in%20cell%20I%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20appreciated.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20Porcha%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVersion%3A%202107%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Porcha_0-1630968329792.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308386i6B79B962E7B33959%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Porcha_0-1630968329792.png%22%20alt%3D%22Porcha_0-1630968329792.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2726313%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2727829%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Icon%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2727829%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1147519%22%20target%3D%22_blank%22%3E%40Porcha%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20the%20range%20in%20column%20I%20that%20you%20want%20to%20format.%3C%2FP%3E%0A%3CP%3EI2%20should%20be%20the%20active%20cell%20in%20the%20selection.%3C%2FP%3E%0A%3CP%3EOn%20the%20Home%20tab%20of%20the%20ribbon%2C%20select%20Conditional%20Formatting%20%26gt%3B%20Manage%20Rules...%3C%2FP%3E%0A%3CP%3EClick%20'New%20Rule...'%3C%2FP%3E%0A%3CP%3ESelect%20'Use%20a%20formula%20to%20determine%20which%20cells%20to%20format'.%3C%2FP%3E%0A%3CP%3EEnter%20the%20formula%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3DJ2%3D%22Complete%22%3C%2FP%3E%0A%3CP%3EClick%20OK%20without%20specifying%20a%20format.%3C%2FP%3E%0A%3CP%3EThe%20new%20rule%20should%20appear%20above%20the%20Icon%20Set%20rule.%3C%2FP%3E%0A%3CP%3ETick%20the%20check%20box%20'Stop%20If%20True'%20for%20the%20new%20rule.%3C%2FP%3E%0A%3CP%3EClick%20OK.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0744.png%22%20style%3D%22width%3A%20629px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308473iBA35C171456086FE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0744.png%22%20alt%3D%22S0744.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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 (Occasional 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