I have thought of that as well- actually I did an if statement, but I thought
a box would be better. I am assuming from the responses this is either not a
good idea or can't be done.
--
Thanks,
Nikki


"JR" wrote:

In cell B1, type "You are over your limit", then change the font color to
white (so it can't be seen). In the same cell, use conditional formatting
("Format", "Conditional Formatting") to change the font color to black when
A1 is 134.16.

"Nikki" wrote:

I want a message box to popup if a cell(which already contains a function) is
over a certain value. Data validation won't work because the user isn't
entering data into the cell. What would be the best way to do this?
Basically- If A1134.16 then MsgBox "You are over your limit"
Thanks for the help!!
--
Thanks,
Nikki