Hi guys,

Just a quick and probably silly question.

I wanted a conditional format for an error where someone puts in text as opposed to a figure and the error: "#VALUE!" come up in a cell.

How can I set a conditional format to alert me with a red background when someone enters text instead of a numeric value in a cell?

Thanks in advance.