This should be easy, but not for me on a Monday...
I need to a formula in cell C1 to test for multiple conditions.
Here's what I have:
Cell A1 and B1 start out blank.
Cell A1 has a Data Validation List with over a hundred choices.
Some of the choices in the Data Validation List for cell A1 begin with an "*" [=if(left(A1,1)="*"].
If A1 is blank do nothing in cell C1 [ie: =if(A1="","")].
If A1 is anything but blank and does not begin with a "*" and cell B1 is blank then cell C1 should equal a 1.
Basically cell C1 should be a "1" if B1 is blank when cell A1 contains anything but a blank that does not begin with a "*".
I also need a Conditional Formatting formula for cell B1 so that I can hightlight B1 if B1 is blank when cell A1 is not blank and A1 does not begin with a "*".
Thanks for any help...
Bookmarks