RANDBETWEEN in a conditional format gives error

[Guest]

When I try to use the RANDBETWEEN function in a condional format (e.g., cell
value = RANDBETWEEN(1,100)), I get the error message "You may not use
references to other worksheets or workbooks for Conditional Formatting
criteria." Why is it telling me this, and how do I get it to work?

 

[MartinW]

Hmm,

Perhaps you could explain what you are trying to achieve.
I'm as confused as Excel with the criteria you have given here.

Regards
Martin

 

[Guest]

Why not use "Cell value is" between 1 and 100?

Hmm,

Perhaps you could explain what you are trying to achieve.
I'm as confused as Excel with the criteria you have given here.

Regards
Martin

 

[Bob Phillips]

It is part of the analysis toolpak, and yu cannot use ATP functions in CF.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gord Dibben]

RANDBETWEEN function is from the Analysis Toolpak which is an add-in.


Gord Dibben MS Excel MVP

 

[Mark Lincoln]

If I correctly understand what you're trying to do, you can get the
same functionality by putting =RANDBETWEEN(1,100) in an unused cell
and referring to that cell in your CF. For example, if your random-
number cell is C3, set CF to Cell Value Is | Equal To | C3.

Mark Lincoln