Creating Error Alert From Logical Function

S

StephonM

How can I create a pop-up error alert everytime the function below puts out a
"False" result?

=AND(F20=COUNTIF(C11:C55,"*"))
 
M

Mike H

Hi,

Firstly there's nothing to AND in your formula so this is sufficient

=F20=COUNTIF(C11:C55,"*")

Unless you want to delve into VB why not use conditional formatting to turn
the cell red if it evaluates as false.

Select the cell then

Format|Conditional format - cell value - Is Equal to
Enter FALSE and pick a colour.

Mike
 
Top