Alerts

[gregork]

I want to have an error alert to notify when a cell's value is outside set
parameters. I tried to do this using data validation but it is not working -
I think because the cell is a formula cell not a data entry cell. Any ideas
?

Cheers
gregorK

 

[RWN]

Depending on what you want as an alert, you could use conditional
formatting and change the font, color etc.
Select your calculated cell.
"Format->Conditional Formatting" - select whatever condition(s) are
applicable
For ex;
Say your valid (non-alert) value is 10, then;
Set "condition 1" to "cell value is" -> "Not equal to" "10"
"Format..."
Set the color("Patterns")/font to whatever you like.

HTH