Alerts

  • Thread starter Thread starter gregork
  • Start date Start date
G

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
 
how about using conditional formatting under the Format menu. Yes, data
validation only works on manually entered data. It doesn't look at the
value in the cell.
 
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
 
Back
Top