My condition has now changed to alert the user if the value is NOT ZERO
(policy change) and is in a list of 5 other pieces of financial information
and I'm afraid this might get lost with all the other information. I'm also
a little concerned that I have so much other conditonal formatting the users
might 'switch' off to the alerts. This condition is one where I really need
to stop them in their tracks before they proceed.

--
Jim


"aneasiertomorrow" wrote:

Hi

You could use conditional formatting so it's really obvious and 'in their
face' when it isn't equal to zero.

Lucy
--
MOS Master Instructor
www.aneasiertomorrow.com.au

If this post answered your question please let us know as others may be
interested too


"Jim G" wrote:

I have a sheet that serves as a summary card for job data. Cell E18 has a
formula that finds and returns the value of the consumable levy on the job
card. Is there a way to prompt or remind users to check this if the value is
zero? A user will almost always need to print the summary, so before
printing may be a good time to remind them.

Hope you can help.


--
Jim