When you say exactly, do you mean that literally?

For example:

required
Required
REQUIRED

None of those *exactly* match. Is that what you want?

--
Biff
Microsoft Excel MVP


"Dave White" wrote in message
...
Hi,

I want to use conditional formatting to highlight a cell where i put in a
specific word.

eg: if I type in the word 'required. the cell changes to red etc... when
the
cell is blank I dont want the cell to do anything.. only when I type in a
'word' and that word has to be letter perfect.. ie... req and it wont
change
the cell colour... it will only change when i type in the word exactly ie
'required'

thanks