S StephonM Jul 21, 2009 #1 How can I create a pop-up error alert everytime the function below puts out a "False" result? =AND(F20=COUNTIF(C11:C55,"*"))
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 Jul 21, 2009 #2 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
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
