Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Error Alert From Logical Function
How can I create a pop-up error alert everytime the function below puts out a
"False" result? =AND(F20=COUNTIF(C11:C55,"*")) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Error Alert From Logical Function
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 "StephonM" wrote: How can I create a pop-up error alert everytime the function below puts out a "False" result? =AND(F20=COUNTIF(C11:C55,"*")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help!!! - logical function for someone not very logical | Excel Worksheet Functions | |||
data validation error alert does not work | Excel Discussion (Misc queries) | |||
Creating an Alert Box | Excel Discussion (Misc queries) | |||
undefined function error when creating xls pivot from mdb qry | Excel Worksheet Functions | |||
Logical AND function | Excel Worksheet Functions |