Forum Discussion
Custom Format icon of infinity values
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....
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"))