Hi reno
not sure exactly what you're saying here, if you're using a formula such as
=COUNTIF(A1:A10,50)
then you need to change the 50 to 55 if that's what you now want to count,
alternatively you can reference a cell in the countif function
=COUNTIF(A1:A10,B1)
and then the countif will update if the value in B1 changes as long as the
calculation mode is set to automatic (tools / options / calculation - ensure
automatic is selected).
hope this helps
Cheers
JulieD
"reno" wrote in message
...
want to use countif and conditional formatting. can you use a variable in
countif?
e.g. say break point is $x.xx and i change, i want the conditional
formatting to change, no problem, but the countif does not change with the
variable value w/o re-entering all.
any ideas
|