STEVENS3010
Board Regular
- Joined
- Feb 4, 2020
- Messages
- 89
- Office Version
- 365
- 2016
- Platform
- Windows
Hi all,
Is anybody able to help me out with an issue using an icon set please?
I would like a tick or a cross to appear (standard icon set) in a particular cell based on the value of another cell being true or false.
So for example, in cell "M2" I would like a green tick to appear if cell "N2" is 'True' or a red cross to appear in "M2" if cell "N2" is false. To be clear, there is a formula in cell "N2" determining the True/False result.
Is there a formula I can use in the rule to get this to work for me? Or is there a simpler solution I may be missing?
Thanks
Is anybody able to help me out with an issue using an icon set please?
I would like a tick or a cross to appear (standard icon set) in a particular cell based on the value of another cell being true or false.
So for example, in cell "M2" I would like a green tick to appear if cell "N2" is 'True' or a red cross to appear in "M2" if cell "N2" is false. To be clear, there is a formula in cell "N2" determining the True/False result.
Is there a formula I can use in the rule to get this to work for me? Or is there a simpler solution I may be missing?
Thanks