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...
- 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.
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.
=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.
