Sep 06 2021 03:56 PM
When cell J is actioned 'complete' can this somehow removed the Icon in cell I?
Any help appreciated.
Thanks, Porcha
Version: 2107
Sep 07 2021 02:48 AM
SolutionSelect 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.
Sep 07 2021 03:54 PM
Sep 07 2021 02:48 AM
SolutionSelect 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.