Icon Set Conditional Format from other cell value

[ollyhughes1982]

Hi,

I have a team sheet setup for my pool team. At present in cells G4:G14 I have conditional formatting working to either turn the cell green (for a win “w”) or red (for a loss “l”). This works fine, but I’d rather if I could use icon sets, as they’ll look better.

This is what it currently looks like:

This is what I'd like to achieve:

I haven’t been able to find / work out a way to do this with text. I know you can do this with numbers, so I have setup a corresponding result column in Y4:Y14 which has “1” for a win and “-1” for a loss. Is there a way that I can use the corresponding number values from the Y column and apply the icon sets to column G?

I don’t want to change the w / l format in G as this would mean a lot of work, changing things across many worksheets.

File can be found here: Pool Teamsheet Example.xlsx

Thanks in advance,

Olly.

 

[Micron]

I was going to play with your file but quickly found this

Show images conditionally | Microsoft Community Hub

I would like to show some images in my Excel spreadsheet only when certain conditions are valid.For example: Only show the image when A1>10 or B4<5.How...

techcommunity.microsoft.com

There is one solution there that appears to be using text values in column A

 

[RoryA]

You can use conditional formatting rules to apply a custom number format of:
;;;[red]●
for l, or:
;;;[green]●
for w

 

[ollyhughes1982]

Thanks, both. I'll give these a try