Conditional Formatting & IF Statements

[LavaDude]

Hi All!

I would like to know if there's a way to do an IF statement as follows:

[If the cell contains any part of the word "VACANT", then do this... ]

I have cells that say "VACANT" and some say "VACANT/NEW TENANT" and I'd
like the formula to recognize both these cells. Hmm... maybe using the AND
or OR formulas would work too, but I'm not familiar with using AND or OR.

I want the cell's font to be red, so I'd use conditional formatting, which
I know how to do...

Thanks in advance!!

LavaDude

 

[Niek Otten]

In Conditional Formatting, use "Formula is" instead of "Cell value is".
For the formula, use something like

=NOT(ISERROR(FIND("vacant",A1)))

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Macgru]

Hi All!

I would like to know if there's a way to do an IF statement as follows:

[If the cell contains any part of the word "VACANT", then do this... ]

I have cells that say "VACANT" and some say "VACANT/NEW TENANT" and I'd
like the formula to recognize both these cells. Hmm... maybe using the AND
or OR formulas would work too, but I'm not familiar with using AND or OR.

I want the cell's font to be red, so I'd use conditional formatting, which
I know how to do...

Thanks in advance!!

LavaDude

why dont you try conditional formatting?
just type in value of cell ="VACANT" and add formatting as you wish
mcg