Custom Format icon of infinity values

[FSyed]

Hi

Can someone please advise me on how can I get the green icon for the value >=0 shown in the example below :

it shows a red icon for the value 0.00%  where it should show green as its +ive value.

Its the infinity value of 0,00%

highlighted with yellow back ground color

Thanks

[FSyed]

Thanks Shaurya again

[FSyed]

I think i have done by adding an additional rule its working at this time but don't this its the correct way to do that

[FSyed]

Thanks as this row hasn't got any Target hence has some Savings (Outurn) i.e. +776  made some profit 

The user say its one of exceptional if the %achieved is 0 or infinity should be green icon

[FSyed]

I think the issue is, how to get round of showing infinity as something other than “Infinity”. 

Showing as zero won’t work with the below logic since zero is <0.85 so will show as Red.

[FSyed]

Thanks, Shaurya for your swift response

As per the rule in this row, Reserves has no Budget(target) but we have achieved and get the positive values but when we calculate the percentage  0/776 = 0.00   (Should show positive or Green)  hope it make sense now

Thanks again for your help

Kind regards,

Farhan

[FSyed]

I can do this in excel like this:

This is the excel script:

=IF(G4<0.85,"RED",IF(AND(G4>=0.85,G4<1),"AMBER","GREEN"))

[Shaurya]

Hi @FSyed,

Your rules are set to show values less than 0.85 with the red icon. Green icon will be visible for values more than 0.99. So can you please eloborate why you want 0 as green and not red?