If then Message Box
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
|