Icon set based on another cell

N

NeoFax

I have a row of information that I would like to check if they meet
certain criteria and then place a icon in the cell using conditional
formatting. Currently my data is like thus:

Material A Planned 1 jan 10 12 jan 10 26 jan 10
Shipped 12 Dec 09 17 Dec 09 23 Dec 09

What I would like to do is have a green icon if shipped is less than
planned - 30, yellow icon if shipped is between planned - 30 and
planned, red icon if >= planned.
 
A

Andy Smith

It's easiest to use conditional formatting to simply color certain cells red,
yellow or green. I don't think displaying on of three graphics is possible.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 dimensional date sort 2
Excel data to horizontal bars 0
Raw data output is poor excel format part 2 - align columns 0
Excel check if dates are under a range of week 4
Reverse Index Match 2
lookup macro 0
display cell content based on date criteria 2
How to determine the highest occurrence? 4

Top