Previous Topic Next Topic

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

Answer 1 / 1
RayH
Nov 18, 2010 at 04:28 PM
=IF(OR(B1="Male",B1="Female"),"DUE","")
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses