Error message if there is a certain statement in a cell

**Engineeronamission** · 10-08-2014, 06:59 AM

Sorry if this is basic. I'm new to Excel.

I have some text in a cell which says 'Insert statement here'. If this is not removed and replaced with a statement I want an error message to show up. I want this to happen when I press a button (so in a macro).

How would I do this?

Many thanks

**Fotis1991** · 10-08-2014, 07:02 AM

You could use Conditional formatting for this.

Assuming that your text is in A2 then in CF rules use this.

Formula:

Please Login or Register  to view this content.

Choose Colour.OK.

How can you use Conditional Formating.

--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.