Conditional formatting using icon sets

[leopardhawk]

Hello forum friends, my worksheet has several cells with conditional formatting rules applied to them that will show a green checkmark, yellow exclamation mark, or a red X depending on the results of the formulas within the cells. Everything is working as it should.

However, when a user first opens the workbook, all of the data entry cells are blank and yet the cells that have the conditional formatting rules in them are still showing either a green check or a red X even though the results are all zero (I was hoping to show the results here so I captured a sample range, but it's not showing the checkmarks for some reason).

My question is to find out if there is a way to hide these green checks and red X's until there are positive results in the cells that they are associated with?

Thanks for any suggestions or ideas.

 

[leopardhawk]

@jasonb75 I used your logic on a couple of dozen formulas and it works great! Thank you! But wouldn't you know it, I get to the last few formulas and I run into a problem! While everything works perfectly on all the other cells where I used it, the last three are giving me problems. If you can help, I will be grateful. The problem in these three cells is likely the same in each so I will focus on just one formula for now. So, this cell (F19), is now returning a result ONLY if there is a value in cell I20. The way I read it is that if I20 is blank, the formula should return F7-(F6+F11) if those three cells all contain a value (which they do). I know the answer has to be something simple but it is eluding me.

Here is the formula:

=IF(I20=0,IF(COUNT(F7,F6,F11)=3,F7-(F6+F11),""),IF(COUNT(F7,I20)=2,(F7-I20),""))

 

[jasonb75]

Does I20 contain a formula? You have done the initial test of I20=0, which means it must be 0 or empty, a formula in I20 that returns "" does not equal 0.

That aside, the formula looks correct based on what I'm seeing in your post.

 

[leopardhawk]

@jasonb75 fantastic! I changed the 0 to "" and problem solved. Thank you so much!