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

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

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

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

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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Dave White" wrote in message
...
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