Forum Discussion
Solved
Conditional Formatting with inside IF statement
I have an Conditional Formatting statement. Working fine.
I need the following changed:
=CONCATENATE("OWNER:",LOT!B8," ASSIGNED:",LOT!C8)
I need the word "ASSIGNED" changed to "INTERRED" IF LOT!D8 has a date inside the cell. ?
Thanks
fordraiders
- is this "Conditional Formatting" or just a conditional statement in a cell?? As for the formula try:
=CONCATENATE("OWNER:",LOT!B8, IF(ISNUMBER(LOT!D8)," INTERRED:"," ASSIGNED:"),LOT!C8)
I used ISNUMBER but if you need to be more specific you could use a date range and require the Value to be inside that range.
2 Replies
- is this "Conditional Formatting" or just a conditional statement in a cell?? As for the formula try:
=CONCATENATE("OWNER:",LOT!B8, IF(ISNUMBER(LOT!D8)," INTERRED:"," ASSIGNED:"),LOT!C8)
I used ISNUMBER but if you need to be more specific you could use a date range and require the Value to be inside that range.m_tarler thank you very much.. looks good so far.
