Chenge Color
Now I try to out conditional formating for that, so if value is greater then or equal to 100%, then change the font color.
Its not working right. It supose to change color only when value is equal to 100% or greater then 100%.
but in my case it was changing color for all value.
but If I have 100% manully (not linked with formula) in some other column,then same condition formating works for that.
But why it does not work with the cell which is based on formula.
Any help please.
Thanks in advance
If you want it to be the NUMBER zero, then you must NOT use the quotes.
Try changing it to 0.
If that doesn't work, maybe you can send the workbook and I'll see if I can figure it out.
Anne@TheOfficeExperts.com
;)
The ONLY time you use quotes in your formula is when you're using TEXT.
So, this:
"0%"
should really just be 0
Also, 100% = 1, so you don't need to measure by 100%.
Percentage is USUALLY just a format. So if you column is formatted for %, and the value in that column is .1, that is:
10%
and 1 (or 1.0) = 100%
Hope that makes sense! (or Percents!)
now its
=IF(SUM(G84:K84)>0,IF((MIN(G84:K84))-B84=0,"0",IF(MIN(G84:K84)
it works now, I mean that conditional formating thing. but it higlight the 0 values as well. Its supose to change color only value which are higher then 100% or equal to 100%. but it change color for value 0 as well. Why is that?
Thanks
:D
=IF(SUM(G6:K6)>0,IF((MIN(G6:K6))-B6=0,"0%",IF(MIN(G6:K6)
#If you have any other info about this subject , Please add it free.# |