Using Excel conditional formatting Icon Sets based on Specific word in other cell won't work?

[khavusr]

I have two sheets in a workbook, SheetA and SheetB, and I'm trying to make use of Excel conditional formatting icon sets to visualize the results better. So what I'm trying to do is that I'm checking a specific cell in Sheet A for a specific word and in my case it's the word "Yes" and the formula that I'm using in Sheet B to do so is the following; =IF(SheetA!D10="Yes","1","0"). Based on that if the word is actually Yes set the cell value to 1 and anything else will give the result 0. But, I noticed that I can't make use of conditional formatting icon set based feature due to that the cell contain a formula or at least this is what I'm believing. Since if I manually deleted the formula and enters 1 myself the conditional formatting works fine.

What is that I'm missing out here to get it to work?

 

[Chrisdontm]

When entering the conditions, are you setting the " value " choice to the number 1, and the " type " over to the right as " Number "...

It should work....

 

[khavusr]

Yes, those options has been set. Also, if I remove the =IF formula from the specific cell and enters manually either 1 or 0 then the conditional formatting works as it should. But, as soon as I enters the formula, =IF(SheetA!D10="Yes","1","0"), the same specific cell then the conditional formatting stops working. I have also tried to use another column to make the formula check on the other sheet if it has something to do with that the conditional formatting doesn't work with certain formulas being used in a cell. But, that didn't make any difference. Is it to be concluded from this that conditional formatting doesn't work when using formulas?

 

[FormR]

Hi, try removing the double quotes from the around the 1 and 0.

i.e.

=IF(SheetA!D10="Yes",1,0)

 

[khavusr]

Hmf! That did the trick and realize that with the quotes it's seen as text and not numbers.

Big Thanks!

 

[FormR]

Glad it worked! Oh, and welcome to the forum