Forum Discussion
Porcha
Sep 06, 2021Copper Contributor
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
Version: 2107
This fixes the output but really ridiculous that I have to do this workaround.
formatDateTime(addDays(outputs('Compose'),1), 'M/d')
2 Replies
Sort By
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.
- PorchaCopper ContributorThanks 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