Quote:
Originally Posted by bala_vb
use wildcard in countif and greater than 0 in conditional formating function
=AND(COUNTIF(A1,"product1*"))0
all the best
|
similarly for other product you can include + (plus) count if functions in excel 2003, if you are using excel 2007, there is multiple criteria supported function called "COUNTIFs"
cheers