Conditionall Formatting Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have the sheet generate an error (alert) message to the user that A cell was left blank that need to to be filled prior to closing

Eexample: IF(D10>0,IF(C10<0," ",)). Something similar to the validation error generator, only, I want to display this message only if D10>0," ", and C10<0," ",. The value in D10 determines the value in C10. If D10 has no vlaue or is blank, then, it's okay to close without error message. However, if D10 does have a value, C10 must also be populated

Thanks for the help!
 
Hi
do you want this message displayed before closing the workbook (that is
using an event macro like Workbook_BeforeClose)?
or would it be sufficient just to highlight the cell C10 if D10 is
filled but C10 is empty 8using conditional format)

Just as a comment: You may change your formula
IF(D10>0,IF(C10<0," "))
to
IF(D10>0,IF(C10<0,""))
In most cases it's better tu return "" instead of a Space character if
a condition is not met
 
Back
Top