Icon set based on another cell value or condition.

Hi Guys,
I have a row of cells with week number w1,w2,w3,w4,w5 and the certain numbers for each rows below the week number.
my requirement is when two numbers are equal(as shown in the picture) then I want a red icon (conditional formatting icon sets) to appear for both the cells whose values are equal.
Attachment 1134
I tried with conditional formatting with icon sets and formulas.its working when the values are equal but when the value changes i get the yellow and green icons as well.
can anyone give me effective solution for this.
Regards,
devpp.

Hi devpp,

Welcome to board !!

Go to Conditional formatting > Manage Rules > Edit rule > and you can set 'No Cell Icon' wherever you want.

Quote:

---

Originally Posted by Admin

Hi devpp,

Welcome to board !!

Go to Conditional formatting > Manage Rules > Edit rule > and you can set 'No Cell Icon' wherever you want.

---

I am ok with the number to displayed.
but when the value is chaged to (say 60) then the icon in one cell changes to yellow color and the other remains red...
my requirement is when the both values are equal then it has to be red icon.when they are not equal then i dont want any icon...

That's what I said. You can set the cells with no icon by editing your existing rule on CF.

Quote:

---

Originally Posted by Admin

That's what I said. You can set the cells with no icon by editing your existing rule on CF.

---

Sorry boss..
I got it now...

Quote:

---

Originally Posted by Admin

That's what I said. You can set the cells with no icon by editing your existing rule on CF.

---

i still cant get it.please find the attached file.
Is the "no icon" option available in Excel 2007?