Function Formatting
 

I would like to know how to have a cell change color when an error occurs...I
know its possible 'cause I have two other cells that turn red when an error
occurs in my entries but I can't figure out for the last one. For example,
cells contain either a COUNTIF or IF formula. When the user enters to many
entries other than what is allowed, the cell will turn red so that you know
an error has occured.

An example of where we are using this: employees are allowed 15 vacation
days, if they are enter 16 days in the planner by mistake, the cell where the
formula is will turn red.

Any ideas what I'm looking for here?

Thank you,
CC

Function Formatting
 

Depends what you mean by "error"

If the cell is truly returning an error type (e.g. "#VALUE!"), then select
cell (I'll assume A2), go to Format, conditional format.
Change first box to "Formula is"
In second box, type
=ISERROR(A2)
Click format, border, red.
Ok to close

If you simply want to limit their input, say nothing bigger than 15, you
would change formula to
=A215
and again select the format you want.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"OC" wrote:

I would like to know how to have a cell change color when an error occurs...I
know its possible 'cause I have two other cells that turn red when an error
occurs in my entries but I can't figure out for the last one. For example,
cells contain either a COUNTIF or IF formula. When the user enters to many
entries other than what is allowed, the cell will turn red so that you know
an error has occured.

An example of where we are using this: employees are allowed 15 vacation
days, if they are enter 16 days in the planner by mistake, the cell where the
formula is will turn red.

Any ideas what I'm looking for here?

Thank you,
CC