icon conditional formating – Excel 2010

Topic

New Reply

Greetings,
I need help to apply icon style format beside cell value based on the following conditions:
If cell value = 0 then no format
If =100 then green icon
If 100 then amber icon
Any ideas how can this be done…

Reply | Quote

Replies

I know a couple of ways to do this – Can you post a sample spreadsheet so I can see exactly what you’re trying to achieve?

I think the easiest way to manage this would be setting up conditional formatting rules, or maybe making a quick script for you which I’m more than happy to give a go!

R

Reply | Quote

My appology, the previous file is not the one,please consider this one

Reply | Quote

dubdub,

Setup a 4 icon set like this:

38580-icons

HTH,
Maud

Reply | Quote

Great Great Thanks Maudibe.

Reply | Quote