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?
What is that I'm missing out here to get it to work?