YUP !!!! perfect !!!

many many thanks... didnt realise it was THAT simple !

"T. Valko" wrote:

Select the cell you want to highlight.
Let's assume it's cell A1
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=A1="required"
Click the Format button
Select the Patterns tab
Select a fill color
OK out

--
Biff
Microsoft Excel MVP


"Dave White" wrote in message
...
Hi... yes... i want the cell to change colour when i type a word in it...
ie:

yellow.... type that in and the cell will highlight... type in yello and
nothing happens.... same with if I type in nothing... i only want the cell
to
change when I type in a word (like yellow) !

"T. Valko" wrote:

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