Conditional Formatting & IF Statements

  • Thread starter Thread starter LavaDude
  • Start date Start date
L

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
 
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
 
U¿ytkownik "LavaDude said:
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
Click to expand...

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