View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] niraj.zaveri@gmail.com is offline
external usenet poster
 
Posts: 1
Default Validate a formula NOT a value

I'm trying to validate that a formula is an array. Essentially, if
someone accidentally changes the formula to a regular formula by
pressing enter this screws up the calculation.

I would ideally like to use conditional formatting to make the field
red to indicate an error.

Thanks,

Niraj