Automatically having text added to one cell

Closed
Chris - Nov 18, 2010 at 09:41 AM
 RayH - Nov 18, 2010 at 04:28 PM
Hello,
I am looking for conditional formatting only. I want to have text entered in one cell based on text in another cell.
Example: If cell "A" is blank and cell "B" has the words "Male" or "Female" added to it (from being blank previously), how can I make cell "A" display the word "DUE"?
If that is not possible, if cell "B" has a date entered in it (from being blank previously), how can I make cell "A" display the word "DUE"?
Thanks in advance,

Chris



1 response

=IF(OR(B1="Male",B1="Female"),"DUE","")
0