Conditional Formatting, icon sets, not working on a column

[LindsayBiss]

Hello,

I am trying to use the Conditional Formatting with the icon sets, and it works on the other columns I have in my spreadsheet, but not in two of the columns. I am wondering if it has something to do with the formula?

The formula I have in the cells where the conditional formatting works is:

The formula I have where it does not work is:

If you could let me know why this is happening, that would be great.

Thank you !!!

Lindsay

 

[6StringJazzer]

What are the conditional formatting rules you are using that don't work?

I suspect it is because your cell formula is returning text, not a number. You should format the cell as "0%" and not do it in the formula. Then your formula becomes:

=IF(ISERROR(J20),"",-J20/D20)

Also, it is much better to paste formulas directly into your post instead of posting pictures of them.

 

[LindsayBiss]

What are the conditional formatting rules you are using that don't work?

I suspect it is because your cell formula is returning text, not a number. You should format the cell as "0%" and not do it in the formula. Then your formula becomes:

=IF(ISERROR(J20),"",-J20/D20)

Also, it is much better to paste formulas directly into your post instead of posting pictures of them.

It worked !!

Thank you very much for the help !!

Lindsay

 

[6StringJazzer]

Glad to help!