Using an icon set with formula

[STEVENS3010]

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

 

[Eric W]

What do you have in M2? A value or formula, or is it just a place for the icon? Icon sets only work on the value in a cell, not the value in another cell. So if M2 is empty, you can put a formula in it referring to N2, like this:

Where the formula in M2 is: =IF(N2,99,0) and the Conditional Formatting is set up like this:

 

[STEVENS3010]

Thanks so much, really appreciate your help.